BJ,
A simple "while" command should do it. Try something
like this:
Advertising
print("<select name=artist>\n");
$qry = "SELECT artist_id, artist FROM $db";
$res = mysql_query($qry) or die(mysql_error());
while($data = mysql_fetch_array($res))
{
print("<option
value=\"$data[0]\">$data[1]</option>\n");
}
print("</option>");
That should do the trick for ya!
Best,
John
>I have two fields artist_id, artist. How do I put
the contents of
"artist" into a dropdown list.
__________________________________________________
Do You Yahoo!?
Great stuff seeking new owners in Yahoo! Auctions!
http://auctions.yahoo.com
--
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]
