Re: Php, MySql dynamic creation of dropdown list

http://www.thickbook.com/extra/php_loopoption.phtml nice little tutorial. its quite simple as you'll see. ----- Original Message ----- From: Dave Carrera <dave@davecarrera.com> To: <php-db@lists.php.net> Sent: Sunday, December 31, 2000 12:22 PM Subject: [PHP-DB] Php, MySql dynamic creation of dropdown list > 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@lists.php.net > For additional commands, e-mail: php-db-help@lists.php.net > To contact the list administrators, e-mail: php-list-admin@lists.php.net > >