On Wednesday, November 24, 2004, at 02:40PM, Norland, Martin <Martin.Norland@xxxxxxxxxx> wrote: >The real problem you're having is the statement says "while there are >results in this query, grab them" - once you reach the end of the first >while loop, there are no more results, so the second one is skipped >right over - it's condition *never* evaluates true. So by running a "while (mysql_fetch_array($result)" loop over a fetch array you effectively empty it? >If the query isn't changing, and there aren't other conditions/etc. - >then just grab all the data the first time through and put it where it >needs to go. OK, sounds like a plan... Sorry (again) about the code gaffs :-S -- Mark Benson http://homepage.mac.com/markbenson -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php