kpetsche20 Posted June 28, 2008 Share Posted June 28, 2008 Problem, when someone clicks on submit only asdfadsf is displayed. Nothing in the loop is displayed and I"m sure that there is a value in the table school with the id of 1 that has a password. Here's the code if(isset($_POST['submit'])) { echo " asdfadsf"; $findpw = "SELECT * FROM school WHERE id = '1'"; $run = mysql_query($findpw); while($data2 = mysql_fetch_array($run)); { echo $data2['password']; } } Quote Link to comment Share on other sites More sharing options...
CMC Posted June 28, 2008 Share Posted June 28, 2008 Try this: <?phpif(isset($_POST['submit'])) { echo "asdfadsf"; $findpw = "SELECT * FROM school WHERE id = '1'"; $run = mysql_query($findpw) or die(mysql_error()); while($data2 = mysql_fetch_array($run)) { echo $data2['password']; } } Will check for errors and display to you if found and also removed a semi-colon ( at the end of your while line. Quote Link to comment 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.