combo box and string
Posted: Tue Feb 27, 2007 7:35 am
hi all,
I have 2 fields first_name, last_name and I want to output both of fhem into combo box. I have done but i doesn't work exactly
and I want it outputted with newline.
Thank in advance
I have 2 fields first_name, last_name and I want to output both of fhem into combo box. I have done but i doesn't work exactly
and I want it outputted with newline.
Code: Select all
<?php
$query = "SELECT last_name,first_name
FROM student
ORDER BY first_name ";
$search_stu=mysql_query($query)or die(mysql_error());
//creat array for last name
$name = array();
//last name into array
while ($row = mysql_fetch_assoc($search_stu))
{
array_push($name, $row["last_name"]);
array_push($name, $row["first_name"]);
}
?>
<select name="name">
<? foreach($name as $value) { ?>
<option value="<?= $value ?>"><?= $value ?></option>
<? } ?>
</select>
</td>
<?= $line["name"] ?>
</td><tr>
</table>