need input on using form to query mysql

[Anon]

I have a mysql table with 10 columns. I have built a form that has 4 dropdown lists matching different column data. I can get the form to to be specific, but if someone needs a listing of everything in the table, I do not know how to either eliminate that part of the query, or the command for all. Example below.

$query = "SELECT * FROM daocitems WHERE itemrealm = '$realm' " AND itemslot = '$slot' AND itemtype = '$type' ;

The variables are from the different dropdowns in form. But what can I put so that nothing is filtered? Or, if I can not do that, how could I change the code to add/remove from the query as needed, the different columnnames?

[ayzee01]

do a check to see if there are any values in the dropdown variables i.e. has the user selected an option for the dropdown - if not then just do a straight forward select all.

eg:

<?
if($realm || $slot || $type)
{
$query = "SELECT FROM daocitems WHERE itemrealm = '$realm' " AND itemslot = '$slot' AND itemtype = '$type' ;
}
else
{
$query = "SELECT FROM daocitems";
}
?>

[Anon]

Thanks for the info and your time Leon. Big Help🙂

[ayzee01]

No problem Terry, glad to be of help.

Leon.