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 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 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 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 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
Archived
This topic is now archived and is closed to further replies.