Hi! I'm new to linux, PHP and MySQL.
I'm having a problem using LIMIT and ORDER BY in the same query. When I use this: SELECT uid,name,uname,email,local,tel FROM users order by name LIMIT 10 , 19 And mysql is returning 14 results. I'm testing, so I replaced the names for numbers to undestand what was going on. The 14 results returned had the following values: Name --------- 11 | --------- 12 | --------- 13 | --------- 14 | --------- 15 | --------- 16 | --------- 17 | --------- 18 | --------- 19 | --------- 20 | --------- 21 | --------- 22 | --------- 23 | --------- 24 | --------- I've read some questions of people with similar problems, and some of them suggested that upgrading the mySQL version would do it. Because I'm new to linux I don't no exacly how to upgrade. Does anyone have another suggestion to the LIMIT problem? Is there a step by step tutorial to upgrade MySQL? Thank's Joao --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
