I am trying to show table data (category) in listbox. But not able to do it. My code is following. <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd"> <html> <head> <title>Untitled Document</title> <meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1"> </head> <body> <?php $con = mysql_connect("localhost","sanganak_manish","manish"); if (!$con) { die('Could not connect: ' . mysql_error()); }mysql_select_db("sanganak_mydata",$con); $result = mysql_query("SELECT * FROM bank where name ='" . $_POST[bank] . "'"); $row = mysql_fetch_array($result); ?> <form name="form1" method="post" action="update_bank.php"> <p>name: <input type="text" name="name" value="<?php echo $row['name']; ?>"> </p> <p> <select name="category" value="<?php echo $row['category'];?>"> </select> </p> <p>Date_of_incorporation: <input type="text" name="date" value="<?php echo $row['date_of_incorporation']; ?>"> <br> Address: <input type="text" name="add" value="<?php echo $row['head_off_add']; ?>"> <br> State: <input type="text" name="state" value="<?php echo $row['state']; ?>"> <br> </p> <p>City: <input type="text" name="city" value="<?php echo $row['city']; ?>"> <br> </p> <p>Country: <input type="text" name="country" value="<?php echo $row['country']; ?>"> <br> </p> <p>Pin: <input type="text" name="pin" value="<?php echo $row['pin']; ?>"> <br> <input type="submit" name="Submit" value="Submit"> <?php mysql_close($con); ?> </p> </form> <p> </p> <p> </p> </body> </html> Please help me to do it.
Instead of <? $row = mysql_fetch_array($result); ?> PHP: use: <? echo "<select name='category'>"; while($row = mysql_fetch_array($result)) { echo "<option value='".$row['category']."'>'."$row['category']".'</option> "; } echo "</select>"; ?> PHP: That should work, Cheers, BP