Mysql Search Assistance

[thewomb]

Im trying to make a search chritera based on multiple vars which ref Fields in mysql

i.e. i want to search for "gender" and "suburb" and have the resutls page mirror this but am having mega problems. im sure its VERY simple but im new to MYSQL

SELECT *
FROM rego
WHERE suburb = 'colname' AND gender = 'colname'

is this right?

obviously not ha ha any help would be most greatfully recirved

TW

[nemonoman]

Typically your SQL query would be based on variables you got through GET or POST type actions.

for example: myhost.com/doit.php?suburb=Tenafly&gender=M

<?

//file doit.php

$suburb=$GET['suburb'];
$gender=$GET['gender'];

//insert your database connect stuff here...

$result=mysql_query("SELECT *
FROM rego
WHERE suburb = '$suburb' AND gender = '$gender'

"
);

//now fetch the resulting rows SELECTED by the query

while($row=mysql_fetch_array($result)){
//do something with the array;
foreach($row as $value){echo $value;}
}
?>