Well I try to avoid the manual , but refer to some
books that I've collected. Essentially the same, but
more palatable for my tastes. Not that I wouldnl't
check the manual.
What I needed was "order by Desc limit (x, x) . In my
case 3 queries, with (0,1)(1,1)(2,1) .
The first 3 records , 1 at a
Here is the manual. I suggest you try a search for "LIMIT" in the
context of a SELECT.
http://dev.mysql.com/doc/mysql/en/index.html
However what it sounds like you really ought to do is give a walk
through the tutorial.
http://dev.mysql.com/doc/mysql/en/Tutorial.html
If, after exploring these
Say it with me:
"The manual is your friend. The manual is your friend. The manual..." -
(it just bit me, too, on another thread) LOL
Shawn Green
Database Administrator
Unimin Corporation - Spruce Pine
Stuart Felenstein <[EMAIL PROTECTED]> wrote on 09/02/2004 11:02:06 AM:
> Wait!!
Wait!! Don't answer...it's that LIMIT
thing.
:)
Stuart
--- Stuart Felenstein <[EMAIL PROTECTED]> wrote:
> I'm tring to extract all records belonging to one ID
> in a table.
> BUT! I want to do it in piece meal. Meaning a
> record
> at a time.
> I am assuming I need some kind of
I'm tring to extract all records belonging to one ID
in a table.
BUT! I want to do it in piece meal. Meaning a record
at a time.
I am assuming I need some kind of count mechanism.
Example:
I want to see the first 3 purchases this member made.
Instead of grabbing them all in one shot, I want t