iNko Posted November 2, 2012 Share Posted November 2, 2012 Hi, i want to select data from a database and that it should be displayed in a select list i have this code: <table width="100%" border="0" cellspacing="0" cellpadding="0"> <tr> <td>Name :</td> <td> <?php $query = mysql_query("SELECT * FROM `table_name`"); while($row = mysql_fetch_assoc($query)){ echo $row['table_row_name']; } ?> </td> </tr> Now it only gets me the data from a row in a table, and writes it in one line. How do i make it so all the data would go into select list and i could only pick one item? Quote Link to comment Share on other sites More sharing options...
ManiacDan Posted November 2, 2012 Share Posted November 2, 2012 Print a select list: <td> <select name="row_name"> <?php $query = mysql_query("SELECT * FROM `table_name`"); while($row = mysql_fetch_assoc($query)){ echo '<option>' . $row['table_row_name'] . '</option>'; } ?> </select> </td> Quote Link to comment Share on other sites More sharing options...
iNko Posted November 2, 2012 Author Share Posted November 2, 2012 Hehe thx i also just found another way: <?php function dropDown(){ $options="<select>"; $query = mysql_query("SELECT * FROM `Valdymo_grupe`"); while ($row=mysql_fetch_array($query)) { $name=$row["valdymo_pav"]; $options.="<option value=\"$name\">".$name."</option>"; } $options.= "</SELECT>"; return "$options"; } $list = dropDown(); echo "$list"; ?> Quote Link to comment Share on other sites More sharing options...
ManiacDan Posted November 2, 2012 Share Posted November 2, 2012 To be clear, this isn't "another way," this is exactly what I suggested. Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.