kts Posted September 24, 2008 Share Posted September 24, 2008 Hello I have this LIMIT 12, 24 which should limit it to only 12 results, but for some reason it is displaying 21 results ( seems to be going to the end of the results) the full sql is select image_id, image_type, image_name, image_link, image_name_secondary, image_link_secondary, DATE_FORMAT(startDate,'%Y%m%d') as startDate, DATE_FORMAT(expirationDate,'%Y%m%d') as expirationDate from press_images where image_id > 1 and expirationDate > 20080924 and startDate <= 20080924 LIMIT 12, 24 anyone know why possibly? i tried running it in phpmyadmin, same result Link to comment https://forums.phpfreaks.com/topic/125685-problem-with-sql-limit-statemnet/ Share on other sites More sharing options...
dennismonsewicz Posted September 24, 2008 Share Posted September 24, 2008 just use this LIMIT 12 Link to comment https://forums.phpfreaks.com/topic/125685-problem-with-sql-limit-statemnet/#findComment-649884 Share on other sites More sharing options...
Barand Posted September 24, 2008 Share Posted September 24, 2008 LIMIT 12,24 means fetch 24 rows starting at row 12 Link to comment https://forums.phpfreaks.com/topic/125685-problem-with-sql-limit-statemnet/#findComment-649936 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.