great thanks guys, exactly what we're looking for!!! Philip Hallstrom wrote: >> i've checked the PHP manual but can't find a function for this, >> perhaps I'm >> missing something. >> >> I get a resultset and loop through it but this is in a loop so it >> only executes >> the first time. is this because the resultset is at the end? is there >> a way to >> tell PHP to start at the beginning of the resultset again for each >> loop? Or is >> it best just to copy the resultset to an array and just loop through >> the array >> multilpe times? > > > if it's mysql, then ... > > http://us3.php.net/manual/en/function.mysql-data-seek.php > > probably exists for other db backends as well... > -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php