yep, that's basically what i use for this sort of thing - it's a nice short simple function, and works a treat. Obviously if you'd rather be passing the actual colour name to the next step, you use printf("<option value=%s>%s</option>", $myrow["colorname"], $myrow["colorname"]); I also prefer to use printf("<option value=\"%s\"> so it has the value in quotes - just a fussy html thing i do though.
-----Original Message----- From: Matthew Crouch [mailto:[EMAIL PROTECTED]] Sent: 13 December 2001 22:58 To: [EMAIL PROTECTED] Subject: [PHP-DB] Re: Dynamically populating a dropdown box I'm no expert, and my code is probably buggy, but I think this is the gist of it: <select name="color"> <? $result = mysql_query("SELECT * from colors"); while ($myrow = mysql_fetch_array($result)) { printf("<option value=%s>%s</option>", $myrow["colorid"], $myrow["colorname"]); } ?> </select> Chris Payne wrote: > Hi there everyone, > > I have a shopping cart which is starting to work nicely, but I have to select size/color from the entries, how do I do this dynamically in PHP with MySQL? I need them to be dropdown form boxes but haven't got a clue how to populate them from the fields of my database. > > Please help me with example code if possible, it would be greatly appreciated :-) > > Thank you everyone > > Regards > > Chris -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED] --- Incoming mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.306 / Virus Database: 166 - Release Date: 04/12/01 --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.306 / Virus Database: 166 - Release Date: 04/12/01 -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]