dif types of sql statements

[Trojan]

hi,

i'm trying to make a search query that searches on a particular criteria. i have done that, if i wantedd to search the tables by anoter criteria would i have to create another form, input field, submit button and another script or can i use the existing one and slightly modify it. i;ve seen sites use this method wid the use of select boxes, can anyone help and explain in great detail

many thanks

Troj

[bastien]

SQL language is easy and allows for many type of options when searching

select * from table where field IN ($somearray)

select * from table where field1 = '$somevalue' and field2='$anothervalue'

select * from table where field='$somevalue' or field='$anothervalue'

select * from table where field like '%$somevalue%'

other attributes include ORDER BY field(sorting)
GROUP BY field (groups like records

so it depends on what you are trying to do. i would suggest a book on mysql/sql language to help get the basics down and build from there

also see www.mysql.com

[Trojan]

cheers bastien,

but i wanted is to know how to change the field that one wants to serach by dynamically. At the moment a user searches by location but i want them to be able to search by postcode all in the same sql command

[bastien]

<?
//rest of your code

$sql="select * from table where ";

if ($POST['location']){ //location choosen
$sql=$sql." location = '$POST['location']'";
}elseif ($POST['postocde']){ //postocde set
$sql=$sql." postcode = '$POST['postcode']'";
}

$result=mysql_query($sql);

//rest of your code

?>

hth