whyz3rman
-
Posts
13 -
Joined
-
Last visited
Content Type
Profiles
Forums
Events
Posts posted by whyz3rman
-
-
dropdown list
in SQL
Hi, I have a short question. The following code, gives me a dropdown menu with name and surname(exactly what I want:), but the name and surname don't have the space between them. Can somebody give me a hint. I suspect that coloured part of the code has to be changed somehow.CODE:mysql_select_db("hockey", $con); $sql="SELECT Surname, Name FROM player"; $result=mysql_query($sql); $options=""; while ($row=mysql_fetch_array($result)) { $Surname=$row["Surname"]; $Name=$row["Name"]; $both.="<OPTION VALUE=\"Surname,Name\">".$Surname.$Name;} mysql_close($con);?> <SELECT NAME=Surname, Name> <OPTION VALUE=0>Choose...<?=$both?></SELECT>
dropdown list
in SQL
Posted
Thanks, will do