Hi, Michael Engelhart hat gesagt: // Michael Engelhart wrote: > I use PostgreSQL and you can do something like: > > SELECT * FROM my_table LIMIT 25 OFFSET 25 > > which would return 25 rows starting with the 25th row in the result set. > > mySQL has something similar I believe which is something like: > SELECT * ... LIMIT 5,10
Yep, you made my day. I was always using Postgres but the shop must run on MySQL and this is the offset syntax I needed. ciao -- Frank Barknecht _ ______footils.org__ ------------------------------------------------------- This sf.net email is sponsored by:ThinkGeek Welcome to geek heaven. http://thinkgeek.com/sf _______________________________________________ Webware-discuss mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/webware-discuss