Topic: help with limit in a sql query

[turkman]

I'm wondering if its possible to get a record of all but the 100 most recent entries using the a lastpost datetime()

i.e SELECT * FROM table WHERE replytoo = '0' ORDER BY Lastpost desc LIMIT(100,1000)

so this query would put the most recently posted records on top then ignore the first 100 and extract 100 to 1000 for example

??

Can you use limit like this?

[Twister1004]

I dont think you can use it like that. I believe you need to use mysql_select() or something, or use mysql_rows in a while loop and then echo those out.

[fenway]

Without the parens, that's valid syntax... but it's not very efficient.