Need Help Selecting Last 10 Rows From Database

[gaza165]

I am trying to run a query to fetch the last 10 records from a table... however

 

$message = mysql_query("SELECT * FROM chat ORDER BY timestamp DESC LIMIT 0,10");

 

this brings back the first 10 not the last 10....

 

help!!

[Maq]

Take out the first '0' after your LIMIT clause.

[gaza165]

That still brings back the first 10.... i want the last 10....

 

 

1

2

3

4

5

6

7

8

9

10    ----->> here onwards....

12

13

14

15

16

17

18

19

20

 

 

[Maq]

Then take out DESC.

[gaza165]

$message = mysql_query("SELECT * FROM chat ORDER BY timestamp LIMIT 10");

 

Nope still brings back the first 10 records...

[Maq]

$message = mysql_query("SELECT * FROM chat ORDER BY timestamp LIMIT 10");

 

Nope still brings back the first 10 records...

 

...

 

SELECT * FROM chat ORDER BY timestamp DESC LIMIT 10

 

AND

 

SELECT * FROM chat ORDER BY timestamp LIMIT 10

 

Should not both bring back the same first 10 records.  Can I see a sample record from your table?

[gaza165]

[Maq]

I don't know what else to say, this should work:

 

SELECT * FROM chat ORDER BY timestamp DESC LIMIT 10

 

You could try this, which should be just as reliable:

 

SELECT * FROM chat ORDER BY id DESC LIMIT 10