dannybrazil Posted January 20, 2010 Share Posted January 20, 2010 Hello I have a table of many entries , and I need to retrieve specific one's ex: "SELECT * FROM pairs WHERE pair='eurusd' AND graph_type='mn' ORDER BY id DESC" now lets say he found 5 entries....(ID 1..2..3..4..5) I need them in this order : 5 4 3 2 1 How can i add a LIMIT the he would NOT print the 5th ID ? (the last one uploaded into the database) Danny Quote Link to comment https://forums.phpfreaks.com/topic/189176-sql-for-all-but-the-first-row/ Share on other sites More sharing options...
Mchl Posted January 20, 2010 Share Posted January 20, 2010 LIMIT 1,4 Quote Link to comment https://forums.phpfreaks.com/topic/189176-sql-for-all-but-the-first-row/#findComment-998736 Share on other sites More sharing options...
dannybrazil Posted January 20, 2010 Author Share Posted January 20, 2010 One more thing I have many entries....and I cant know before how many he will find while searching It mean 5 was just a # I need something general * sql can come up with 5 or 10 or 1000....I just dont want to show the last entry Quote Link to comment https://forums.phpfreaks.com/topic/189176-sql-for-all-but-the-first-row/#findComment-998741 Share on other sites More sharing options...
dannybrazil Posted January 20, 2010 Author Share Posted January 20, 2010 got it I just got the number as variable and added it to the limit LIMIT 1,$number Thanks Quote Link to comment https://forums.phpfreaks.com/topic/189176-sql-for-all-but-the-first-row/#findComment-998757 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.