load data in to combobox from database

[savanm]

Hi all,

I have one doubt. How to load data from the databse in to combobox..

I have a mysql table login

two fields in the table namely user and password

I want to load the list of user's into the combobox..

Thanks

Navas.M

[mainul]

Hi all,

I have one doubt. How to load data from the databse in to combobox..

I have a mysql table login

two fields in the table namely user and password

I want to load the list of user's into the combobox..

Thanks

Navas.M

Hi Navas,
Try this out.

[PHP]
<? $name= mysql_query("se lect * from table_name"); ?>

<select name="user" id="user">
<? while($res= mysql_fetch_ass oc($name))
{ ?>
<option>
<? echo $res['table_field']?>
</option>
<? }?>
</select>

[/PHP]

Best regards,
Mainul

[savanm]

Hi..

It help to solve my problem

Thanks Guy
Navas

[samarulraj]

nice frd i got it

[samarulraj]

thank you friend works fine-------------------