SQL Query

[rubbersoul]

Here is the query I have now:

SELECT theatre, location, address, phone
FROM loaded_theatres
WHERE location = 'colname'

with the variable being:
colname $HTTP_POST_VARS['slt_area']

That is for one list menu....what if I wanted to have two...like they choose location and/or name....the above is for location only
(the 'slt_area' is the list menu for location)

[kevinsequeira]

$colname = $HTTP_POST_VARS['slt_area']
$colname2 = $HTTP_POST_VARS['name']

$query = "SELECT theatre, location, address, phone FROM loaded_theatres";

$query_where = " WHERE location = 'colname'"

if($colname2!="")
$query_where .= " AND theatre = '$colname2'";

$query = $query.$query_where;

print($query); // to check if its fine

also im assuming the name variable in the form refers to the variable theatre in the table ...

reg
kevin