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 ; ?> Quote 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"]) . ""; Quote 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! Quote 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
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.