SQL Limit

[gaza165]

I have an SQL query that fetches all the entries in a database expect from the last one in the table...now i need to limit it to the last 10 records ordered by timestamp.

 

can anyone help??

 

<?php

include ('dbconnect.php');

$message = mysql_query("SELECT * FROM (SELECT * FROM chat ORDER BY timestamp DESC LIMIT 1,18446744073709551615) Deriv1 ORDER BY timestamp ASC ");



while ($row = mysql_fetch_array($message))
{
	echo "<li><h2>".$row['nick'].": </h2><p class='word-wrap'>".$row['message']."</p></li>" ;
}

?>

[gaza165]

help!!

[aschk]

Heh Gaz, not that bad is it?

I'm not sure why you're trying to work from a derived table, considering you're just doing another SELECT on it.

 

SQL query to fetch chat in last to 1st ordering.

SELECT * FROM chat ORDER BY timestamp DESC

 

SQL query to fetch chat; last 10 items starting from the 2nd to last

SELECT * FROM chat ORDER BY timestamp DESC LIMIT 1,10

 

You might want to review how the LIMIT clause works (http://dev.mysql.com/doc/refman/5.1/en/select.html)

 

Of course I might have totally missed the point of the question, or what you were really after.