Ordering results

scraff

hi, i am trying to order results DESC, i know the default is ASC.

I want to show the last 10 entries in the database for last few registered members on hedcase.co.uk

$query = @mysql_query("SELECT * FROM CDBmembers WHERE website = '1' ORDER DESC LIMIT 10");

This doesnt work tho, it returns nothing

And if i use:

$query = @mysql_query("SELECT * FROM CDBmembers WHERE website = '1' LIMIT 10");

It just shows the first 10.

Any help thanks!

wempy

The clause is actually ORDER BY field_name ASC | DESC

$query = @mysql_query("SELECT * FROM CDBmembers WHERE website = '1' ORDER BY field_name DESC LIMIT 10");

scraff

Thats the problem, i dont want to order it by a name of a field, just the LAST 10 that were entered. Just wondered if there was a way to do this. Just how the default orders ASC, from the first entered to the last

$query = @mysql_query("SELECT * FROM CDBmembers WHERE website = '1' LIMIT 10");

I need some way to reverse this.

Thanks

xblue

Hi scraff,

unfortunately I believe there isn't even a default order - the data is written to the disk where there is space availalable as far as I know, which may be at the end but not necessarily is.

Do your records have a unique ID, something auto-incrementing probably? If they do, this could be easily used as sorting criteria.

If they don't, maybe there is a column that logs the insertion date that could be used, but you should think about giving them IDs anyway, it is extremly important for an efficient data structure when the database grows and gains more tables that are related to this one.

scraff

They have unique IDs but not auto increasement. I think thats what i will have to do then, thanks.

liquorvicar

why not use

ORDER BY unique_id DESC LIMIT 10

this will pull off the last 10 ordered by your unique ID (i.e. the highest 10 IDs). if you have a date field you could also use that instead.

scraff

yes i will add unique id field with auto increasment. thanks