While statement problem

[kpetsche20]

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'];
}
}

[CMC]

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.