Re: select a certain num of items in sql query

2002-03-28 Thread denonymous
From: "Aman Raheja" <[EMAIL PROTECTED]> > Suppose I want to select items 10 to 30 from a table tab, which has 36 rows. > What could be the sql query ? > Thank you. > Aman > > PS: I am using cgi-perl. How are these items identified as "items 10 to 30" in the table? Does that mean that when you

Re: select a certain num of items in sql query

2002-03-28 Thread Tyler Longren
This worked for me: SELECT * FROM table ORDER BY id ASC LIMIT 9,21; There's probably a better way to do that though. tyler - Original Message - From: "Aman Raheja" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Thursday, March 28, 2002 2:04 PM Subject: se

select a certain num of items in sql query

2002-03-28 Thread Aman Raheja
Suppose I want to select items 10 to 30 from a table tab, which has 36 rows. What could be the sql query ? Thank you. Aman PS: I am using cgi-perl. _ MSN Photos is the easiest way to share and print your photos: http://photos.msn.