Re: [PHP] finding a particular record within a MySQL result set

On Wed, April 4, 2007 12:07 pm, James Tu wrote: I've cross posted this to the MySQL list... Here's my original post. Is there some quick way to do the following in MySQL? (I know I can use PHP to search through the result set, but I wanted to see if there's a quick way using some sort of

[PHP] finding a particular record within a MySQL result set

I've cross posted this to the MySQL list... Here's my original post. Is there some quick way to do the following in MySQL? (I know I can use PHP to search through the result set, but I wanted to see if there's a quick way using some sort of query) Let's say I know that Joe is from Maine.

RE: [PHP] finding a particular record within a MySQL result set

I've cross posted this to the MySQL list... Here's my original post. Is there some quick way to do the following in MySQL? (I know I can use PHP to search through the result set, but I wanted to see if there's a quick way using some sort of query) Let's say I know that Joe

RE: [PHP] finding a particular record within a MySQL result set

You will probably get a better approach from the mysql list, but from a PHP solution perspective, I'd load up an array with the result set and use key() to get the number. The example at http://php.net/key does exactly that. Or array_search() :) JM -- PHP General Mailing List

Re: [PHP] finding a particular record within a MySQL result set

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 On Apr 4, 2007, at 1:39 PM, Jim Moseby wrote: You will probably get a better approach from

RE: [PHP] finding a particular record within a MySQL result set

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.

Re: [PHP] finding a particular record within a MySQL result set

2007/4/4, James Tu [EMAIL PROTECTED]: I've cross posted this to the MySQL list... Here's my original post. Is there some quick way to do the following in MySQL? (I know I can use PHP to search through the result set, but I wanted to see if there's a quick way using some sort of query)