Set the new array before your for loops, then loop over the array. -Craig
>>-----Original Message----- >>From: Mark McCulligh [mailto:[EMAIL PROTECTED]] >>Sent: Thursday, December 12, 2002 4:56 PM >>To: [EMAIL PROTECTED] >>Subject: Re: [PHP] PHP + MySQL looping question >> >> >>If I understand you if you use the mysql_query($sql) again won't >>it rerun my >>SQL again, not just reprint. >> >>Example: >> >>$result = mysql_query($sql); >>for ($i = 1; $i <= 3; $i++) { >> while ($row = mysql_fetch_array($result)) { >> //Some Code >> echo $row['filed']; >> } >> //Reset result array >> $result = mysql_query($sql); >>} >> >>-- >>_________________________________________ >>Mark McCulligh, Application Developer / Analyst >>Sykes Canada Corporation www.SykesCanada.com >>(888)225-6824 ex. 3262 >>[EMAIL PROTECTED] >>"Craig Thomas" <[EMAIL PROTECTED]> wrote in message >>[EMAIL PROTECTED]">news:[EMAIL PROTECTED]... >>> >>The problem is I have to reset the SQL result array on each for >>> >>loop. How do >>> >>you do that? >>> >>> $myNewArrayFullofSqlResultsThatICanLoopOverAsManyTimesAsIWant = >>> mysql_query($sql); >>> >>> -Craig >>> >> >> >> >>-- >>PHP General Mailing List (http://www.php.net/) >>To unsubscribe, visit: http://www.php.net/unsub.php >> >> -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php