[SOLVED] Conflicting database results

[86Stang]

I'm doing a SELECT from the database and getting a conflict in the results.

 

$sql = "SELECT * FROM members";
$result = mysql_query($sql) or die('Query failed.');

echo "You currently have " . mysql_num_rows($result) . " records.<br><br>";

$i=1;
while ($row = mysql_fetch_array($result))
{	
echo "#" . $i . " - " . $row[19] . "<br>";
$i++;
}

 

The resulting output is:

 

"You currently have 39 records" ... but when I do the while loop, it only shows 38 records.  Any thoughts?

[teng84]

because you have fetch already one data before you loop

remove that fetch above and you should be fine

[teng84]

men did you edit your post.. i believe better to post your new code than editing your original thread

this confused readers.i have posted answer already. is it my eyes that has a prob i believe i've seen 2 fetch array

[PFMaBiSmAd]

LOL. The code in the first post was edited. Kind of makes you want to quote entire posts when you reply to them, even though that clutters up the thread, so you have a record in your post of what you were providing an answer to, so as not to look foolish.

 

86Stang, it is impolite to change your question.

[86Stang]

Sorry about the edit.  You're answer to my (pre-edited) post was dead on.  Thanks!!

[86Stang]

Again, my apologies.