Código PHP:
include 'dataconnect.php';
$sql="SELECT name, last FROM person";
$result = mysql_query($sql) or die (mysql_error());
if(mysql_num_rows($result)==0){
echo "No data was found";
}
else{
echo "<select>";
while($row=mysql_fetch_array($result)){
echo "<option value='".$row['name']."'>".$row['name']." ".$row['last']."</option>";
}
echo "</select>";
}
Código PHP:
<div id="content" class="unhide">
Select an user from the list:
<select name="users">
<?php
$sql="SELECT name, last FROM person ORDER BY name";
$result=mysql_query($sql) or die(mysql_error());
while($row=mysql_fetch_array($result)){
echo "<option value='".$row['name']."'>".$row['name']." ".$row['last']."</option>";
}
?>
</select>
</div>
Código PHP:
<div id="content" class="unhide">
Select an user from the list:
<select name="users">
<!--?php
$sql="SELECT name, last FROM person ORDER BY name";
$result=mysql_query($sql) or die(mysql_error());
while($row=mysql_fetch_array($result)){
echo "<option value='".$row['name']."'-->".$row['name']." ".$row['last']."";
}
?>
</select>
</div>