also, to get existing vals to show in the select as default, <select name="colorz"> while($row=mysql_fetch_array($result)){ $selected=($row["ID"]==$ID)?"selected":""; echo "<option value='" . $row["ID"] . "' $selected>" . $row["name"] . "</option>\n"; } </select> the value can be in single quotes also, altho i dont think quotes matter unless you use opera or some other wierdass browser (you can also put doubles using \") I believe (correct me if im wrong) that since echo is a construct and not a predefined function, it runs faster.
"Matt Stewart" <[EMAIL PROTECTED]> wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... > 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]