While loop problem

[chestnuth]

Hi,

 

The while loop below always produces 1 less record that i have in the database. I've checked the sql and it returns the correct number of rows. So i'm guessing the problem is with my while loop? However, i cannot find the problem!

 

Any help would be great!!

 

if($view == '1')
{
$i=0;
print "<table align=\"center\"summary=\"Returnall records\" class=\"xxx\" cellspacing=\"0\">";
print "<tr>";
print "<td class=\"tableheadercc\">header1</td>";
print "<td class=\"tableheadercc\">header2</td>";
print "<td class=\"tableheadercc\">header3</td>";
print "<td class=\"tableheadercc\">header4</td>";
print "<td class=\"tableheadercc\">header5</td>";
print "<td class=\"tableheadercc\"></td>";
print "</tr>";
while($rowName=mysql_fetch_array($resultName))
{
$i++;
             print"<tr class=\"r".($i & 1)."\">";
print"<td  width=\"155\">".$rowcc['data1']."</td>";
print"<td>".$rowcc['data2']."</td>";
print"<td>".$rowcc['Data3']."</td>";
print"<td>".$rowcc['data4']."</td>";
print"<td>".$rowcc['data5']." ".$rowcc['data6']."</td>";
print"<td>".$rowcc['data7']."</td>";
print"</tr>\n";
}
print"</table>";
}

[BlueSkyIS]

you while starts while($rowName

 

but then you reference $rowcc inside of it. what is $rowcc?

[kenrbnsn]

Please show us the code leading up to the while loop. You probably have another mysql_fetch() function there.

 

Ken