npsari Posted May 11, 2007 Share Posted May 11, 2007 Hi there everybody... I have this simple retreive code: mysql_select_db(Database); $q = "SELECT * FROM info ORDER BY Date ASC, Time ASC LIMIT 50;"; I want the code to ignore the first 5 results i.e. start from result 6 How can I pass the first 5 results? Thanks Link to comment https://forums.phpfreaks.com/topic/50983-solved-retreive-data-from-mysql-databse-relatevly-simple-question/ Share on other sites More sharing options...
Barand Posted May 11, 2007 Share Posted May 11, 2007 ... LIMIT 5, 50 Link to comment https://forums.phpfreaks.com/topic/50983-solved-retreive-data-from-mysql-databse-relatevly-simple-question/#findComment-250847 Share on other sites More sharing options...
per1os Posted May 11, 2007 Share Posted May 11, 2007 <?php mysql_select_db(Database); $q = "SELECT * FROM info ORDER BY Date ASC, Time ASC LIMIT 5,50;"; ?> Link to comment https://forums.phpfreaks.com/topic/50983-solved-retreive-data-from-mysql-databse-relatevly-simple-question/#findComment-250851 Share on other sites More sharing options...
npsari Posted May 11, 2007 Author Share Posted May 11, 2007 Thanks guys Link to comment https://forums.phpfreaks.com/topic/50983-solved-retreive-data-from-mysql-databse-relatevly-simple-question/#findComment-250856 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.