SELECT order

spectacell

select * from kläder where datum = '20030113145245' or datum = '20021209074219' or datum = '20021209073952' 

if (!($result = mysql_db_query($DB,$query))) 
{...}

while(($row = mysql_fetch_array($result))){
  echo $row["size"];

}

when I run this code I would like "20030113145245" first, "20021209074219" next and so on. For some strange reason this is not what happens.

I get everything the other way aroun. Is there anyway to flip the order?

Best regards!
/Emil

DigitalExpl0it

"select * from kläder where datum = '20030113145245' or datum = '20021209074219' or datum = '20021209073952' ORDER BY datum DESC"

try this

spectacell

Thank you but I don't want it to order by datum I want it to write it out in the exact order of the query.

I am going to use this code in a shoppingcart and datum is like the product ID and the order is the order people has added the item to the cart.

I have some variables in cookies so I really need everything in the right order. Otherwise the cookie values and the values from the Database doesn't match up.

You could say it gets like this now:

1...3
2...2
3...1

I want it like:
1...1
2...2
3...3

where left numbres are cookie values and right numbers are values from the database.

(In the cookies I store things that users has selected, like color and quantity.)

Lars_Berg

select * from kläder
 where datum = '20030113145245' 
or datum = '20021209074219' 
or datum = '20021209073952' 
order by case datum
when '20030113145245' then 1
when '20021209074219' then 2
when '20021209073952' then 3
else 4 end

spectacell

sorry Lars but I don't really understand what you mean...

elacdude

i wish i could help, but im in the same situation as you. i was wondering how to do that

spectacell

yeah it's really weird...

jabba_29

Have you got anything else in your table that can be ordered by?

I.e. ID (that is autoincremented) ??

Just a thought 😉

spectacell

umm nope but I don't want it to be ordered. I want it in the same order as it's written.

"select * from kläder where datum = '20030113145245' or datum = '20021209074219' or datum = '20021209073952' "
Is generatade by a loop that checks what the person has put in the cart.

Lars_Berg

Did you try the select statement I proposed? There is no other way than building an order by clause in parallel with build the where clause.

spectacell

Lars:

I didn't quite understand what you meant by your code.