RE: [PHP] finding a particular record within a MySQL result set
| From: | Jim Moseby | Date: | Wed, 04 Apr 2007 18:19:09 +0000 |
| Subject: | RE: [PHP] finding a particular record within a MySQL result set | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-252064@lists.php.net to get a copy of this message | ||
>
>
> I've looked at those, but both approaches requires traversing
> through
> the entire mysql result set to create another array ( could
> be memory
> intensive if the result set is large...100,000 ? )
>
> -James
>
I agree. That's why I said the mysql group will give you better answers.
Really, the best solution is to just get your answer from mysql. I am 100%
sure you can forge an SQL query or series of queries that will return the
number you want.
JM