Justtechjobs.com Find a programming school near you






Online Campus Both


php-db | 2001011

[PHP-DB] Php, MySql dynamic creation of dropdown list From: Dave Carrera (dave <email protected>)
Date: 12/31/00

Hi All
I would like to create a dropdown selection list getting the item selected
from my MySql db and then including the item selected into to SQL statement
so that users only get shown the relevant rows according to the item they
have selected.

The field I want to manipulate is $month. So the dropdown list will show
only one instance of $month as I have many of the same month listed in
$month.

Then when selected they get back from my db all rows with the selected
$month.

I think my SQL will read something like.

SELECT * FROM db WHERE $month="value from dropdown list"; ( I think )

I am searching the web to try and find the answer but if any of you could
through some pointers on how to accomplish this then I will be most
grateful.

Dave ;-) 

-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: php-db-unsubscribe <email protected>
For additional commands, e-mail: php-db-help <email protected>
To contact the list administrators, e-mail: php-list-admin <email protected>