LIMIT isn't working prperly
Posted: Wed Apr 12, 2006 11:37 am
Hello,
I have a big problem with LIMIT, and it's frustrating the heck out of me. Basically, I need to display 12 results at a time. My database has 18 entries (at the moment). This is a user search. Below are entries from my actual database, copied and pasted through phpmyadmin:
first without the limit:
Now I try to use the limit:
So basically, it replicates one of the users, while swallowing another one. But it swallows a user from the middle of the table, which is very very weird. Can anyone give me a pointer?
Thanks.
I have a big problem with LIMIT, and it's frustrating the heck out of me. Basically, I need to display 12 results at a time. My database has 18 entries (at the moment). This is a user search. Below are entries from my actual database, copied and pasted through phpmyadmin:
first without the limit:
Code: Select all
SELECT `id` , `age` , `username` , `gender`
FROM `users`
WHERE id >0
AND `username` LIKE '%%'
ORDER BY `popularity` DESC
Edit Delete 2 20 Vlad Male
Edit Delete 1 19 Vitali Male
Edit Delete 10 21 DESIGNER Male
Edit Delete 104 19 silverbelle Female
Edit Delete 108 17 imDrej Male
Edit Delete 111 17 jrstar Male <====WATCH THIS ONE
Edit Delete 107 16 NY_PLAYA Male
Edit Delete 105 19 Mike Male
Edit Delete 103 18 Paul Male
Edit Delete 102 18 iDuke Male
Edit Delete 101 24 Sercher Male
Edit Delete 11 18 Liii Female
Edit Delete 9 20 TOO_HOT Female <====WATCH THIS ONE
Edit Delete 106 18 JonathanR Male
Edit Delete 8 18 vlad_test Female
Edit Delete 4 18 Arthur Male
Edit Delete 109 18 Jack87 Male
Edit Delete 110 18 Mikebob Male
Total rows: 18Code: Select all
SELECT `id` , `age` , `username` , `gender`
FROM `users`
WHERE id >0
AND `username` LIKE '%%'
ORDER BY `popularity` DESC
LIMIT 0 , 12
Edit Delete 2 20 Vlad Male
Edit Delete 1 19 Vitali Male
Edit Delete 10 21 DESIGNER Male
Edit Delete 104 19 silverbelle Female
Edit Delete 108 17 imDrej Male
Edit Delete 107 16 NY_PLAYA Male
Edit Delete 105 19 Mike Male
Edit Delete 103 18 Paul Male
Edit Delete 102 18 iDuke Male
Edit Delete 101 24 Sercher Male
Edit Delete 11 18 Liii Female
Edit Delete 9 20 TOO_HOT Female <===WATCH THIS
Look: No jrstar!
Total Rows Returned: 12
SELECT `id` , `age` , `username` , `gender`
FROM `users`
WHERE id >0
AND `username` LIKE '%%'
ORDER BY `popularity` DESC
LIMIT 12 , 12
Edit Delete 9 20 TOO_HOT Female <===see? It returns this again! And still no jrstar....
Edit Delete 106 18 JonathanR Male
Edit Delete 8 18 vlad_test Female
Edit Delete 4 18 Arthur Male
Edit Delete 109 18 Jack87 Male
Edit Delete 110 18 Mikebob Male
Total Rows Returned: 6Thanks.