And the problem is? João Rosa - Dimensão Global wrote:
> 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 > > > --------------------------------------------------------------------- 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
