Query results "Less 1"?

[Mr_Mako]

Hi...

I'd like to have a query result where I can get the results all the way up to the last row, but not include that last row in the result.

For example:

USERS Table:

id	|  name	|    address	| phone_no	|    email	|
---------------------------------------------------------
01	| Bob	| 123 Jasmin	| 234-2345	| [email][e-mail][/email]	|
02	| Will	| 345 Raymond	| 080-4363	| [email][e-mail][/email]|
03	| Frank | 243 Yellow	| 098-2453	| [email][e-mail][/email] |
04	| Larry | 934 Opel	| 823-9492	| [email][e-mail][/email] |

$connect = @mysql_connect("localhost", "username", "password") or die(mysql_error());
$db = @mysql_select_db("database", $connect) or die(mysql_error());

$query = "SELECT * FROM users ORDER BY id";
$result = @mysql_query($query, $connect) or die(mysql_error());

while ($row = mysql_fetch_array($result)) {
     $id = $row['id'];
     $name = $row['name'];
     $address = $row['address'];
     $phone = $row['phone_no'];
     $email = $row['email'];
}

What I'd like to be able to do is get every result EXCEPT the last one (in this case, id# 04). I know there's a command that can be used (ie, "Less"), but I'm unfamiliar with it's use.

[barand]

Maybe something like

$query = "SELECT * FROM users ORDER BY id"; 
$result = @mysql_query($query, $connect) or die(mysql_error()); 

$n = mysql_num_rows($result);

while ($row = mysql_fetch_array($result)) { 
     $id = $row['id']; 
     $name = $row['name']; 
     $address = $row['address']; 
     $phone = $row['phone_no']; 
     $email = $row['email'];
     if (--$n==1) break; 
}