i'm a complete newbie with regards mysql/php and i'm woprking on my first project. I am trying to querie the database with the user having a choice of functions. my first function works ok but the next one:
elseif ($submit == "Search by Priority")
$result = mysql_query("select * from mytable_name WHERE $prigall$lessequalmore$moreorless limit $numbresults");
where $prigall is a field in mytable_name
$lessequalmore is a drop down box with values of >, ==, <
and $moreorless is a dropdown box with numeric values.
and $numbresults is just a limit on the number of results to display.
As i say my first function works fine but this one goes to the results page with no error but doesn't show any results. I'm obviously doing something (very) stupid but i've played around with variations of that and it won't work, i think i'm on the right track but if anyone's got any idea it'll be very appreciated.