mcmuney Posted March 25, 2012 Share Posted March 25, 2012 I'm having an issue where MySQL results is not showing the very first result, here's my code: $sql = "SELECT b.winner,COUNT(b.winner) AS count, p.sci_url as pic FROM sc_battle AS b, sc_member_images AS p WHERE b.scm_mem_id = ".$current_user." AND b.winner = p.scm_mem_id AND sci_rating = 1 GROUP BY b.winner HAVING count>$wins ORDER BY count DESC LIMIT 11"; The code is pulling the correct data; however, it's missing one result. I have specified "LIMIT 11", but I see only 10 results. When I set LIMIT 9, I get 8 results. In every case, the very first result is not showing up. Any thoughts on fixing this issue? Link to comment https://forums.phpfreaks.com/topic/259669-result-missing-first-value/ Share on other sites More sharing options...
trq Posted March 25, 2012 Share Posted March 25, 2012 Post your code. Link to comment https://forums.phpfreaks.com/topic/259669-result-missing-first-value/#findComment-1330926 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.