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 Quote Link to comment Share on other sites More sharing options...
dennismonsewicz Posted September 24, 2008 Share Posted September 24, 2008 just use this LIMIT 12 Quote Link to comment 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 Quote Link to comment 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.