Re: Clarification: Jump to a record/PHP paging...

On Sun, 2006-12-24 at 11:22 -0500, tedd wrote: > > > Again, in my opinion, that's fuzzy thinking. Sure, Yeti may be in the > >> monster sub-set, but how much monster it is as compared to Lockness? > >> You need a means, a yardstick, to compare the two with each other. > >> Like, is Lockness bigger than the Yeti while monster-mouse is > >> smaller, or what? > > > >Who the hell cares, I asked for any entry with monster in the > >description, I didn't say make higher level philosophical debate within > >your head as to the level of monsteriness. Quit trying to paint shades > >of gray when all that lies before you is black and white. We have an > >order, the order in the dictionary, we have a query for which results > >are returned using the same ordering criterion as in the dictionary. > > Rob: > > If YOU are doing a FULL TEXT search within a description field > looking for the word "monster" and reporting all those records that > fulfill the search, then I agree with YOU, but that's not what the > POSTER was asking. In fact, I already discussed a FULL TEXT search in > a previous post re this subject. > > The poster asked: > > >... my question is: how might I have MySQL tell me how many records > >came BEFORE the found record? > > So, if he followed your advice/technique, then tell us how many > records came before "monster"? > > I claim you can't. WRONG! See Martin Alterisio's post for the same thread. You must not have understood the OP's requirements. > >He has already decided an order so your rebuttal is completely devoid of > >additional content. > > You are arbitrarily inferring that the order was alphabetical, but he > did not say that. > > However, if he had, then please explain how you would use a FULL TEXT > search to find the word that came BEFORE "monster"? I would be very > interested to see how that's done. We all can learn. Yep, you definitely didn't understand the requirements. Tsk tsk. BTW, Merry Christmas :D Cheers, Rob. -- .------------------------------------------------------------. | InterJinn Application Framework - http://www.interjinn.com | :------------------------------------------------------------: | An application and templating framework for PHP. Boasting | | a powerful, scalable system for accessing system services | | such as forms, properties, sessions, and caches. InterJinn | | also provides an extremely flexible architecture for | | creating re-usable components quickly and easily. | `------------------------------------------------------------'