ramkich4u Posted January 16, 2012 Share Posted January 16, 2012 hi... i am using below query for display food article in my site SELECT news.post_id, news.title FROM news WHERE Blog_Type = 'Food' ORDER BY news.post_id DESC LIMIT 6 Display like below record post_id title 1 63 some food article content 2 61 some food article content 3 58 some food article contencontencontenconten 4 52 some food article content 5 48 some food article contencontencontenconten 6 42 some food article content I don't want to display 1 record... i want to display from 2 to 7 row num.. please help me Quote Link to comment Share on other sites More sharing options...
trq Posted January 16, 2012 Share Posted January 16, 2012 SELECT news.post_id, news.title FROM news WHERE Blog_Type = 'Food' AND record != 1 ORDER BY news.post_id DESC LIMIT 6 Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.