Php, MySql dynamic creation of dropdown list

From: Date: Sun, 31 Dec 2000 12:22:07 +0000
Subject: Php, MySql dynamic creation of dropdown list
Groups: php.db 
Request: Send a blank email to php-db+get-5518@lists.php.net to get a copy of this message
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 ;-)

« previous php.db (#5518) next »