chestnuth Posted March 19, 2008 Share Posted March 19, 2008 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>"; } Quote Link to comment https://forums.phpfreaks.com/topic/96927-looping-problem-math-based/ Share on other sites More sharing options...
sasa Posted March 19, 2008 Share Posted March 19, 2008 in while loop you fetch result in variable $rowName but in print you use variable $rowcc Quote Link to comment https://forums.phpfreaks.com/topic/96927-looping-problem-math-based/#findComment-496180 Share on other sites More sharing options...
Barand Posted March 19, 2008 Share Posted March 19, 2008 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. Quote Link to comment https://forums.phpfreaks.com/topic/96927-looping-problem-math-based/#findComment-496244 Share on other sites More sharing options...
hamza Posted June 11, 2008 Share Posted June 11, 2008 initialize your variable $i with 1 not with 0. may be this will be your answer or sulotion Quote Link to comment https://forums.phpfreaks.com/topic/96927-looping-problem-math-based/#findComment-563035 Share on other sites More sharing options...
Barand Posted June 11, 2008 Share Posted June 11, 2008 @ 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 Quote Link to comment https://forums.phpfreaks.com/topic/96927-looping-problem-math-based/#findComment-563058 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.