php mysql query a table for the last set number of rows

Question

I would like to construct a mysql_query that will give me only new rows inserted in a table with a where condition like ....

SELECT (LAST 5) FROM `x`  WHERE `USER_KEY` = '$RK' ORDER BY `dd` DESC

this data will be parsed in json afterwards,otherwise i would have just got all the data and looped threw.

juergen d · Accepted Answer · 2012-05-12 06:49:06Z

2

you can reverse the order and get the first 5. That is the same as getting the last 5 and sorting the other way around

SELECT * FROM `x`  WHERE `USER_KEY` = '$RK' ORDER BY `dd` ASC limit 5

or if you need the desc order you can do

select * from (SELECT * FROM `x`  
               WHERE `USER_KEY` = '$RK' 
               ORDER BY `dd` asc 
               limit 5) as x 
order by `dd` desc

edited May 12, 2012 at 6:49

answered May 12, 2012 at 5:26

juergen d

205k40 gold badges305 silver badges377 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

eggyal Over a year ago

Surely your second example will select the first 5? You'd need to use the first query as the subquery and then apply an ORDER BY in the parent query simply to change the order of the results.

Collectives™ on Stack Overflow

php mysql query a table for the last set number of rows

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related