[SOLVED] While Loop not returning the first row?

[ifusion]

Hey,

 

My while loop isn't returning the first row, only the second and third rows of data etc? Why is that and how do i fix it?

 

<?php while($row = mysql_fetch_array($result)) {
			echo "<tr>";
			echo "<td>". $row['invoice_date']. "</td>";
			echo "<td>". $row['due_in']. " days". "</td>";
			echo "<td>". $row['invoice_id']. "</td>";
			echo "<td>". $row['client_name']. "</td>";
			echo "<td align=\"right\">"."$". $row['amount_due']. "</td>";
			echo "</tr>";
} ?>

 

Cheers,

Fusion.

[garry]

It's because you're calling the $row function twice. I assume you've already set the $row variable before that block of code? Just delete the other $row and it should work.

[ifusion]

Awsome dude, I had the

$row = mysql_fetch_array($result)

in a included file.

 

Cheers man.