first row in DB query not showing up

[LordMerlin]

Hi my fellow developers & coders

I run the following command, and the first row doesn't show up. The $num_domain_rows shows 4, yet the while loop only displays 3, why would this be?

$domain_result = mysql_query ("SELECT * FROM domain_accounts WHERE activated='0'") or die (print mysql_error()); 
$num_domain_rows=mysql_num_rows($domain_result);
$domain_row = mysql_fetch_array($domain_result);

if ($num_domain_rows > 0) {  

 while($row = mysql_fetch_array($domain_result)){ 
    print 'Domain id '.$row[id].'<br>';
 }
}

[eoghain]

You are seeing this result because you have already made a call to [man]mysql_fetch_array/man outside of your while loop. Every time you call [man]mysql_fetch_array/man it updates the pointer into the result set automatically so that you can write code like your while statement. But since you've called it once outside of your while, you've already moved 1 record into the result.

To fix this you should re-write your code to be like this:

$domain_result = mysql_query ("SELECT * FROM domain_accounts WHERE activated='0'") or die (print mysql_error());  

$num_domain_rows=mysql_num_rows($domain_result); 

// Remove this line
// $domain_row = mysql_fetch_array($domain_result); 

if ($num_domain_rows > 0) {   

 while($row = mysql_fetch_array($domain_result)){  

    print 'Domain id '.$row[id].'<br>'; 
 } 
}