
I want the name to appear as Sean Lister, not SeanLister
Code: Select all
<?
$sql="SELECT id, firstname, surname, room, direction FROM doctors";
$result=mysql_query($sql);
$options="";
while ($row=mysql_fetch_array($result)) {
$docid=$row["id"];
$firstname=$row["firstname"];
$surname=$row["surname"];
$options.="<OPTION VALUE=$docid $surname>".$firstname.$surname;
}
?>Any suggestions?
Thanks thanks