View Single Post
Old 05-30-2007, 09:12 AM   #20 (permalink)
sde
Moderator
 
sde's Avatar
 
Join Date: May 2002
Location: us.ca
Posts: 4,444
sde is on a distinguished road
yes, but see post #2

the query to select the second record would look like this:
Code:
select * from table limit 2,1
but like i say in post 2, .. not a good idea since the second record could change depending on how many users are using the app.

just use IDs.. there is absolutely no valid reason not to.
__________________
Mike
sde is offline   Reply With Quote