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

2007-04-10 Thread Richard Lynch
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

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

2007-04-04 Thread Martin Alterisio
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)

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

2007-04-04 Thread Jim Moseby
> > > 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 answe

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

2007-04-04 Thread James Tu
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

2007-04-04 Thread Jim Moseby
> > 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

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

2007-04-04 Thread Jim Moseby
> > 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 k