Re: problem with mysql_fetch_array

$query4 = mysql_query("SELECT result FROM TBL_result WHERE survey_no=2"; while($row2 = mysql_fetch_array($query4)) { //print array } this will print whole array. i just want to print a row at a time and it should be in the loop because i am printing other things as well. can you tell me how to print a row at a time. actually as i explained earlier, i am able to print a row at a time but when it becomes i=1 and starts outer loop for the second time it just printing the same values. any suggestion? thanks, deepak Justin Patrin wrote:

On Wed, 11 Aug 2004 17:13:49 -0400, Deepak Dhake <dhaked@mail.rockefeller.edu> wrote:

i am trying to print some values from a table with using mysql_fetch_array in a loop but not able to get correct values. it works fine for the loop i=0, prints all desired values but when it bocomes i=1 and starts the loop again the result values gets reset and prints the same old values. for example: outout of the query is result 1 result 2 result 3 result 4 result 5 result 6 result 7 result 8 result 9 result 10 result 11 result 12 :when i=0, it runs through the loop and prints result 1 result 2 result 3 result 4 result 5 result 6 :which is perfect. :but when i=1, it prints the same values, result 1 result 2 result 3 result 4 result 5 result 6 why is that so? can anyone help me? thanks in advance. $query4 = mysql_query("SELECT result FROM TBL_result WHERE survey_no=2";

for($i=0; $i < 2; ++$i)        //surveys

{

   for($j=0; $j < 2; ++$j)        //questions

{

       for ($k=0; $k < 3; ++$k)    //sub-quesions
       {
           $row2 = mysql_fetch_array($query4);
           //Printing all result values one by one
       }

} }

I'm not sure what you think this should do, but you're assuming that 2 * 2 * 3 (12) records will be returned, no more, no less. I doubt this is the case. Normally, such things are done like this: $query4 = mysql_query("SELECT result FROM TBL_result WHERE survey_no=2"; while($row2 = mysql_fetch_array($query4)) { //print array } If this isn't what you want, perhaps you should be doing 3 seperate queries in there? Please explain why you have 3 for loops around your fetch;