php - I want to ascend and decend MYSQL from a value in the database -


I want to assume MYSQL with value in the database. Hypothetically: Database with table is <10> value 10 in column number I want to:

  order from order {8} to LIMIT 3  

to show it

  8 7 6  

instead of:

  numbers According to serial numbers 3 10 9 8  

if it is possible Php and not mysql it is also good.

- Update! -

The example I had given was the easy way, I really need to match the date () in the entry database and start from there or start to bend any thoughts? Date format is in 2010-06-18

  DESC limits by numbers 3,3  

The first argument for the boundary (10 entries + 1) - 3; The second argument is that the number of records for the return

alternatively:

  numbers & lt; = 8 order numbers DESC limit 3  

Comments