AW: [PHP-DB] mysql rereading result set (fetch_assoc)

2007-01-10 Thread Jörg Spilker
-- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] mysql rereading result set (fetch_assoc)

2007-01-09 Thread Niel Archer
Hi > Hi, I would ask which way is more efficient and save time? Save each row to > array or mysql_data_seek(0) ? That totally depends on which resources are more valuable to you. The array will likely use more memory but be faster to process. While mysql_data_seek(0) would probably use n

Re: [PHP-DB] mysql rereading result set (fetch_assoc)

2007-01-09 Thread Chris
christine wrote: Hi, I would ask which way is more efficient and save time? Save each row to array or mysql_data_seek(0) ? Probably mysql_data_seek(0). That just resets the mysql pointer back to the start and so it doesn't re-run the query or anything like that and doesn't take up any extra

RE: [PHP-DB] mysql rereading result set (fetch_assoc)

2007-01-09 Thread christine
[PHP-DB] mysql rereading result set (fetch_assoc) Hi > I'm running thru a result set using fetch_assoc. Now I want to run through > it again. > > How? Save each row into an array first time around, then reset the array pointer to the beginning, would be one way. Or assu

Re: [PHP-DB] mysql rereading result set (fetch_assoc)

2007-01-09 Thread niel
Hi > I'm running thru a result set using fetch_assoc. Now I want to run through > it again. > > How? Save each row into an array first time around, then reset the array pointer to the beginning, would be one way. Or assuming you're using the original MySQL functions, use mysql_data_seek(0

[PHP-DB] mysql rereading result set (fetch_assoc)

2007-01-09 Thread larry
I'm running thru a result set using fetch_assoc. Now I want to run through it again. How? TIA, Larry Woods -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php ** IMPOR

Re: [PHP-DB] mysql rereading result set (fetch_assoc)

2007-01-06 Thread Niel Archer
Hi > I'm running thru a result set using fetch_assoc. Now I want to run through > it again. > > How? Save each row into an array first time around, then reset the array pointer to the beginning, would be one way. Or assuming you're using the original MySQL functions, use mysql_data_seek(0

[PHP-DB] mysql rereading result set (fetch_assoc)

2007-01-06 Thread lwoods
I'm running thru a result set using fetch_assoc. Now I want to run through it again. How? TIA, Larry Woods -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php