multiple selects

[brk1221]

Hi, I have an html form with 1 listbox. The "action=" points to a .php script. If a user chooses an option in the list box it will return the records with the selected criteria. I would like to add more listboxes to the form but I'm having trouble with the SELECT statement. The lone listbox is named "title" and the following is my select satement:

$sql = "SELECT * FROM contacts WHERE (title='$title')";

Any help would be appreciated

Thanks

 

[sleipnir214]

Give the other select elements differing names. Use their values in your SQL query using the AND operator:

$sql = "SELECT * FROM contacts WHERE title='$title' AND someothercolumn = '$someotherelementname'";

Want the best answers? Ask the best questions:

http://www.catb.org/~esr/faqs/smart-questions.html

TANSTAAFL!

 

[brk1221]

When doing that, I select options from either listbox and it returns 0 records.

$sql = "SELECT * FROM contacts WHERE title='$title' AND mla_no='$mla_no'";

In the database there is a record where the "title" is
VP SAFETY and "mla_no" is 115 when I plug in those selections I'm getting 0 records.

Thanks

 

[sleipnir214]

Do the standard debugging.

Output your SQL query to the browser and examine it. Does it look as it should?

Copy and paste the query to your favorite MySQL management tool. What does the query return?

Want the best answers? Ask the best questions:

http://www.catb.org/~esr/faqs/smart-questions.html

TANSTAAFL!

 

[brk1221]

How do I output the query to the browser?

Thanks

 

[DRJ478]

Try:
echo($sql);

 

[sleipnir214]

or

print $sql;

Want the best answers? Ask the best questions:

http://www.catb.org/~esr/faqs/smart-questions.html

TANSTAAFL!