A Conversation for Website Developer's Forum
MySQL question
Frankie Roberto Started conversation Mar 20, 2003
Hmm, just noticed that this entry is categorised in Abi's out tray...
Anyway, my question is, when you send an SQL querey to select a load of records from the database, and those records are ordered on a certain field (eg date or alphabetical), how do you 'skip' a certain number of results from the beginning?
eg. something like "SELECT * FROM * ORDER BY date SKIP 9 LIMIT 12"
I could just receive all the records, and skip some of them in the PHP script, but that would be slower...
MySQL question
dElaphant (and Zeppo his dog (and Gummo, Zeppos dog)) - Left my apostrophes at the BBC Posted Mar 20, 2003
SELECT * FROM * ORDER BY date LIMIT 9, 12
MySQL question
Frankie Roberto Posted Mar 20, 2003
Cheers for the fast response - did the trick.
Actually, think I probably knew that but forgot the syntax. I don't actually *know* SQL, just know enough to use it, mainly by copying and pasting bits from code i've already written.
MySQL question
dElaphant (and Zeppo his dog (and Gummo, Zeppos dog)) - Left my apostrophes at the BBC Posted Mar 20, 2003
Isn't that how we all do it? I just happened to know exactly where I had used that before.
MySQL question
DoctorMO (Keeper of the Computer, Guru, Community Artist) Posted Mar 20, 2003
I thought was the way all programming worked?
Oh well.. 
-- DoctorMO --
Key: Complain about this post
MySQL question
- 1: Frankie Roberto (Mar 20, 2003)
- 2: dElaphant (and Zeppo his dog (and Gummo, Zeppos dog)) - Left my apostrophes at the BBC (Mar 20, 2003)
- 3: Frankie Roberto (Mar 20, 2003)
- 4: dElaphant (and Zeppo his dog (and Gummo, Zeppos dog)) - Left my apostrophes at the BBC (Mar 20, 2003)
- 5: Frankie Roberto (Mar 20, 2003)
- 6: DoctorMO (Keeper of the Computer, Guru, Community Artist) (Mar 20, 2003)
More Conversations for Website Developer's Forum
Write an Entry
"The Hitchhiker's Guide to the Galaxy is a wholly remarkable book. It has been compiled and recompiled many times and under many different editorships. It contains contributions from countless numbers of travellers and researchers."