envexlabs Posted October 9, 2007 Share Posted October 9, 2007 Hey, I have a product page which grabs a product, lets say the ID = 1. At the bottom of the page it grabs the 2 latest products created by that user. I would like it to grab the next 2 products in the database instead of the latest. So, Product 1 Other Products Product 5 and Product 6 Anyone have any ideas? envex Quote Link to comment https://forums.phpfreaks.com/topic/72495-offset-mysql-table-result-by-one/ Share on other sites More sharing options...
GingerRobot Posted October 9, 2007 Share Posted October 9, 2007 Sorry? You want to get the most recently added products? If so just modify your query to only select 2 items, and have it orded by the time added in descending order: $sql = "SELECT * FROM `yourtable` ORDER BY `time` DESC LIMIT 2" Quote Link to comment https://forums.phpfreaks.com/topic/72495-offset-mysql-table-result-by-one/#findComment-365597 Share on other sites More sharing options...
envexlabs Posted October 9, 2007 Author Share Posted October 9, 2007 Hey, no, instead of grabbing the latest products, i want it to show the next 2 products from product #1. Quote Link to comment https://forums.phpfreaks.com/topic/72495-offset-mysql-table-result-by-one/#findComment-365615 Share on other sites More sharing options...
Barand Posted October 9, 2007 Share Posted October 9, 2007 SELECT * FROM product WHERE id <> 1 LIMIT 2 Quote Link to comment https://forums.phpfreaks.com/topic/72495-offset-mysql-table-result-by-one/#findComment-365647 Share on other sites More sharing options...
envexlabs Posted October 10, 2007 Author Share Posted October 10, 2007 Hey, That seems to work, but it's only displaying 3 out of 6 products. ie. I have products 4, 8, 15, 18, 19, & 20. When i am viewing products 4, the products at the bottom are 8 & 15. If i cycle through all of them, i only ever see 4, 8 & 15. Quote Link to comment https://forums.phpfreaks.com/topic/72495-offset-mysql-table-result-by-one/#findComment-366475 Share on other sites More sharing options...
Barand Posted October 10, 2007 Share Posted October 10, 2007 change to "SELECT * FROM product WHERE id >$selectedProduct LIMIT 2" Quote Link to comment https://forums.phpfreaks.com/topic/72495-offset-mysql-table-result-by-one/#findComment-366477 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.