Sorting 'date' SQL result with weekday

[farsen]

Hi.

Im new to PHP/SQL, and have this little tricky problem i cant find a solution for:

$result = mysql_query("SELECT * FROM Activities ORDER BY weekday");

while($row = mysql_fetch_array($result))
{
    echo $row['weekday'];
}

Now this will output

Monday
Sunday
Thursday
Tuesday
etc. - in alpabetic order.

Instead, i want it to sort in:

Monday
Tuesday
Wednesday
and so on..

Furthermore, I´m from denmark, so the result should be printed with danish weeknames:

Mandag (monday)
Tirsdag (tuesday)
and so on..

How do I do this? :S

Thanks alot :)

[pritaeas]

You could sort by DAYOFWEEK() which takes a date column as input. Your output would be 1 .. 7 which you can map to the day name as you please.

http://dev.mysql.com/doc/refman/5.1/en/date-and-time-functions.html#function_dayofweek