Hi

I do need to every time that I promote a specific iproduct from a list of many products into another list I do need the last promoted stays into the top of that list.
ID DESC or ID ASc will order them by ID.

I just want that the last to be at the top

thanks

JS

What do you mean? :P Below is what i think you mean.

If you want them ordered by an ID do the following

"SELECT `tablename` ORDER BY ID ASC LIMIT 0,15"

Let me break is down and explain it all

"SELECT `tablename`" - Selects the table.
"ORDER BY ID" - Tells MySQL to order by the ID.
"ASC" - Makes the information Ascend.
"LIMIT 0,15" -Limits to 15 ID's, starting from 0.

If you want most recent sort by date descending.

ok people

Probably I do not explain right. What do I need is to chose the one that must be at the top
If I use DESC the the highest reference it will be at the top. But sometimes the one that I want to be at the top is one product that has a in bettwen references
for instance if I have 5 products from 1 to 5 I want that some times for promotions the number 4 or next day the number 3. those are the ones that I want to appear at the top.
Desc will give me from 5 to 1 and ASc fron 1 to 5.
i hope that I explain properly now
thanks

Hi,

This would depend on the table structure, but if you for example have a bit field for active promotion you could then for example.

Order by ActivePromotion, ID Desc

This would list all the active promotions at the top ordered by id and then all the following promotions also ordered by id.

If you do not have an existing field you will have to create something that can be used to order by.