son.of.the.morning Posted September 15, 2010 Share Posted September 15, 2010 I want the user to input there name, then have a php script to find the memeber in a members database and then grab the whole row by the user name. so if my db has 3 colums id, user, password, then want it to take out all three fields based on the users name. Can anyone help me? Link to comment https://forums.phpfreaks.com/topic/213512-selecting-an-individual-field/ Share on other sites More sharing options...
JAY6390 Posted September 15, 2010 Share Posted September 15, 2010 http://www.w3schools.com/PHP/php_mysql_select.asp Link to comment https://forums.phpfreaks.com/topic/213512-selecting-an-individual-field/#findComment-1111468 Share on other sites More sharing options...
coupe-r Posted September 16, 2010 Share Posted September 16, 2010 $result = mysql_query("SELECT * FROM "TABLE" WHERE username = '".$_POST['username_txt']."'"); $row = mysql_fetch_array($result); echo $row['username']; username_txt = the name of the text box the user entered data into. username = the username column in the database Link to comment https://forums.phpfreaks.com/topic/213512-selecting-an-individual-field/#findComment-1111521 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.