[Resolved] not displaying all query results

beach_nc

I am having trouble getting the results from my query to display all of the records. The code I have displays everything accept the first result of the query. Can someone take a look at my code and offer suggestions. Thank you. It works correctly at the console.

$query = "SELECT * from providerinfo,team where providerinfo.module=team.teamnumber order by providerinfo.module, providerinfo.lastname, providerinfo.firstname";
$result = mysql_query($query);

$name_row = mysql_fetch_array($result);

while ($name_row = mysql_fetch_array($result)) {

print ("
<div align=center>
<table width = 35% cellspacing=0 cellpadding=0 border=0>
<tr>
<td width = 20%>$name_row[1], $name_row[2]</td>
<td width = 10%>$name_row[3]</td>
<td width = 5%>$name_row[7]</td>
</tr>
</table>
</div>
");

kevinsequeira

remove $name_row = mysql_fetch_array($result);
before the while loop

when this line is executed you get the first row of your result, now when you write it again inside the while loop it gets the next row ie the second row.
so your first row gets skipped.

reg
kevin

ir4z0r

you're executing mysql_fetch_array($result); before the loop

remove this line, cause this is already done in the loop

beach_nc

Thanks!!! that fixed it. I am still learning this and I don't have much of a programming back ground. If it isn't too much trouble could someone explain the logic behind why it wasn't working.

Thank you again.

kevinsequeira

like i mentioned in my post, when you do this

$name_row = mysql_fetch_array($result);

the first row of the resultset is stored in $name_row,

when you call
$name_row = mysql_fetch_array($result) in the while loop, you are fetching the next row. so $name_row is overwritten with the second row.

thats how the while loops works cause for each call of mysql_fetch_array you keep getting the consequent rows of the resultset

reg
kevin

beach_nc

Right, I got it now. I am a little dense today - too many vodka tonics last night.

Thanks for all you help.