View Single Post
  #6  
Old 12-18-2003, 06:29 AM
lagmann
Fire Beetle
 
Join Date: Mar 2002
Location: Montreal, Canada
Posts: 3
Default Re: mysql control center-prolly stupid question:)

Quote:
Originally Posted by Marratook
i have my query set to 1000, and it only show 1000 querys, but its always the first 1000 posts, ie items has about 26000 post if i want it to show that last 1000 post as 25000-26000 can i edit that somewhere?
Here the query to return the last 1000 item :

Select * from items order by ID desc limit 1000;


Quote:
Originally Posted by Marratook
Also if i want it to show post/ids 2455-3455 is there anyway to do this?
Select * from items where (id between 2455 and 3455);

hope that help
__________________
If it move KILL IT! NO! NO! NO! Don't eat it!
Reply With Quote