List:General Discussion« Previous MessageNext Message »
From:Gerald Clark Date:October 31 2001 4:16pm
Subject:Re: LIMIT
View as plain text  
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 <mysql-thread89577@stripped>
> To unsubscribe, e-mail
> <mysql-unsubscribe-gerald_clark=suppliersystems.com@stripped>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
> 
> 
> 

Thread
LIMITJoão Rosa - Dimensão Global31 Oct
  • Re: LIMITGerald Clark31 Oct