[SOLVED] PHP is skipping first line of MYSQL database! help!

[uknoi]

I am trying to display the result of a MYSQL database using PHP. But for some reason it is skipping the first row, so that the display is incomplete. Not sure why.

 

$connect = mysql_connect("", "", "") or die(mysql_error());

mysql_select_db("reviewdata") or die(mysql_error());

$result = mysql_query("SELECT * FROM schools") or die(mysql_error());

$r = mysql_fetch_array( $result );

 

echo $r['school'];

while($r = mysql_fetch_array($result))

{

$school = $r["school"];

echo $school;

}

 

 

Totally ignores the first row in the output.

But I am successfully able to extract the data in the first row by placing "echo $school" before the while statement-- however I should not go through this extra code right??

 

 

$connect = mysql_connect("", "", "") or die(mysql_error());

mysql_select_db("reviewdata") or die(mysql_error());

$result = mysql_query("SELECT * FROM schools") or die(mysql_error());

$r = mysql_fetch_array( $result );

 

echo $r['school'];

 

echo $r['school'];

while($r = mysql_fetch_array($result))

{

$school = $r["school"];

echo $school;

}

 

 

HELP!

[smerny]

remove the red:

 

$connect = mysql_connect("", "", "") or die(mysql_error());

mysql_select_db("reviewdata") or die(mysql_error());

$result = mysql_query("SELECT * FROM schools") or die(mysql_error());

$r = mysql_fetch_array( $result );

 

echo $r['school'];

 

echo $r['school'];

while($r = mysql_fetch_array($result))

{

$school = $r["school"];

echo $school;

}

 

 

 

having "$r = mysql_fetch_array( $result )" before the while statement takes the first row, so you are going to the second row

[uknoi]

MANY MANY THANKS!