No it will give you the same value twice...
you need a loop
<SELECT NAME="state" SIZE="1">
<OPTION VALUE="Canberra">ACT</OPTION>
<OPTION VALUE="Victoria">VIC</OPTION>
looping the rows .,...{
echo "<OPTION VALUE=\"".$row['state']."\">".$row['state_abbr']."</OPTION>
";
}
</SELECT>
Sincerely,
Maxim Maletsky
Founder, Chief Developer
PHPBeginner.com (Where PHP Begins)
[EMAIL PROTECTED]
www.phpbeginner.com
-----Original Message-----
From: Peter Houchin [mailto:[EMAIL PROTECTED]]
Sent: Friday, February 23, 2001 1:17 PM
To: PHP MAIL GROUP
Subject: [PHP] <select name=....
if i have a form with a select box in it how an i get the values to echo a
php value ...
ie
<SELECT NAME="state" SIZE="1">
<OPTION VALUE="Canberra">ACT</OPTION>
<OPTION VALUE="Victoria">VIC</OPTION>
</SELECT>
can i change it to say
<SELECT NAME="state" SIZE="1">
<OPTION VALUE="<? echo $state ?>">ACT</OPTION>
<OPTION VALUE="<?echo $state ?>">VIC</OPTION>
</SELECT>
so that when the page loads it shows which ever option is in the Data base?
Peter Houchin
Sun Rentals
[EMAIL PROTECTED]
--
PHP General 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]