Looping Problem....

[bostonmacosx]

Hey here is the problem. I'm doing a nested loop where the outside loop is a "for" loop and the inside loop is a while loop. Below is the code. What was happening was that the for loop is acting correctly however the while is only going through the loop once and then not again.....any suggestions are welcome and appreciated.

$test2 =mysql_query("SELECT email from co298012004f where coursenum = '$_SESSION[coursenum]' and instructor='0'") or die("Invalid Query test2");



for($i=1;$i<=16;$i++){



$result = mysql_query("INSERT into syllabus (coursenum,week_num,class_date,due,disc_topics,assignment,revealed,submit_req,due_date) VALUES ('$_SESSION[coursenum]','$i','1041397200','Enter Here','Enter Here','Enter Here','1','N','1041397200')");

while($row_test2=mysql_fetch_array($test2)){

mysql_query("INSERT into assignments (coursenum,email,week_num,due_date) VALUES ('$_SESSION[coursenum]','$row_test2[email]','$i','1041397200')");

reset($test2);

}

}

[ahundiak]

mysql_data_seek($test2,0);
instead of
reset($test2);