I'm quite new to mysql/php so this is probably an easy to solve question for some of you guys but i just can's seem to find it.

I want to extract data from my table using the arguments submitted in a search form.

Is it possible to add these arguments in the WHERE statement that i use to select data from the table?

Of should i work with the result from the query.

For instance: i got a table containg id, coursetype, name, institution.

So if i want to check for all data where coursetype=master and
name LIKE%biology% how should i do this.

Thanx a lot in advance

sorry guys,

Found the answer on this same forum page.

You can use the AND and OR statements! great, Why is this not listed somehwere on php.net or so (or why can't i find it :))

Rogier

Oh, i'm still stuck with a question:

If in a search forum a field is left blank, How do i prevent it that nothing gets selected.

For instance i have the following line of code
$id=$_GET['id'];
$coursetype=$_GET['coursetype'];
$name=$_GET['name'];

//connect to db
$query = "SELECT * from courses WHERE coursetype= '$courestype' AND name LIKE %$name% ORDER BY name";
$result = mysql_query($query);

NOW if someone leaves the name field blank, nothing gets selected? or does everything? should i fill $name with an asterisk if it is empty?

Plz let me know