Looping, problem math based?

[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! not sure if it is because of the math i am doing to give each row an alternate name and thus css formatting etc...

 

Any help would be great!!

 

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>";

}

[sasa]

in while loop you fetch result in variable $rowName but in print you use variable $rowcc

[Barand]

The most common reason for a missing row is a call to mysql_fetch_xxxx() between the query and the start of the while() loop.

[hamza]

 

initialize your variable $i with 1 not with 0.

 

 

              may be this will be your answer or sulotion

[Barand]

@ hamza,

 

It would be more helpful if you were to put your energies into helping with current problems instead of resurrecting three-month old topics