retrive data from DB into selectbox

Anon

i'ld like to know how to retrive data from database to select box in the html.
ex: i give my data at the time of registration.after that whenever i loggedin all the fields which belongs to my account info are filled automatically whenever i visited that page.
like:www.brainbench.com site

Anon

what you need to do is to select the stuff you want from the database and then put them into the values fields in the <input> tags...

if there was no data found in your select the fileds will just be empty so there is no need to check that either...

Andreas Bernhardsen

Anon

Well the easiest way would be to just use a for loop, and iterate through all the different tables of a database, and have the output of each iteration go into a <OPTION> tag.

Anon

Example (ripped from working code)

<?
$result = mysql_db_query($db,"select * from $prattle_users where uid='$uid' ");
$user = mysql_fetch_object($result);
?>
<h1>Edit profile: <? echo $user->username; ?> </h1>
<P>Real name: <? echo "$user->firstname $user->lastname"; ?>
<FORM method="POST">
<INPUT type="hidden" name="returnto" value="<? echo $HTTP_REFERER ?>">
<P>Email: <BR>
<INPUT type="text" name="email" size="65" value="<? echo $user->email ?>"><BR>
<INPUT type="radio" name="email_public" value=1
<? if ($user->email_public) echo "CHECKED" ?> >Address is public<BR>
<INPUT type="radio" name="email_public" value=0 <? if (!$user->email_public) echo "CHECKED" ?>>Address is private<BR>
<P>Personal homepage: <BR><INPUT name="homepage" type="text" size="65" value="<? echo $user->homepage
?>"><BR>

Et cetera.