mattichu Posted December 15, 2011 Share Posted December 15, 2011 for some reason my code only posts the first word of the username even tho the last names are in the database. www.checkmyweave.co.uk/new/dropdown.php dropdown.php <?php mysql_connect("localhost","****","****"); mysql_select_db("checkmyw_database") or die("Unable to select database"); ?> <form action="/new/dropdown2.php" Method="POST"> User:<select name="username"> <?php $result = mysql_query("SELECT * FROM members") or die(mysql_error()); while($row = mysql_fetch_array( $result )) { echo "<option value=".$row['username'].">"; echo $row['username']."</option>"; } ?> </select> <form action="/new/dropdown2.php" METHOD="POST"> <input type = "submit" value="New!"> </form> dropdown2.php <?php $username=$_POST["username"]; echo $username ; ?> Link to comment https://forums.phpfreaks.com/topic/253191-drop-down-list-only-posts-first-word/ Share on other sites More sharing options...
requinix Posted December 15, 2011 Share Posted December 15, 2011 Use quotes around attributes and htmlentities on values. echo "" . htmlentities($row["username"]) . ""; Link to comment https://forums.phpfreaks.com/topic/253191-drop-down-list-only-posts-first-word/#findComment-1297986 Share on other sites More sharing options...
mattichu Posted December 15, 2011 Author Share Posted December 15, 2011 Thankyou! Link to comment https://forums.phpfreaks.com/topic/253191-drop-down-list-only-posts-first-word/#findComment-1297989 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.