[Resolved] [Resolved] SQL Question - Date/Weekday Order

[Pilly]

Ok, another question....

Heres my SQL which works perfectly.

$sql = "SELECT , count() AS cnt , DATE_FORMAT(datestamp,'%W') AS mydatestring
FROM phplog
WHERE phplog.field1='$id' AND MONTH(phplog.datestamp) = '$mnth'
GROUP BY mydatestring
ORDER BY DATE_FORMAT(datestamp,'%W')
";

Now the results are:
Friday 4
Monday 4
Thursday 4
Tuesday 1
Wednesday 6

Any ideas how i can get this to sort, starting with monday and ending with friday?
is it obvious?

[cahva]

Havent tested but you could use:
ORDER BY DATE_FORMAT(datestamp,'%w')

So that way it should order by weekdaynumber.

[Pilly]

nice one.
Top of the class to you! 🙂

Thanks a lot

[Pilly]

Now aother question. what happens if on a thursday there was no records, how can i get it to appear but with 0 as an entry?

[nlhowell]

You can't; you could check for missing days with PHP, and stick in the 0 entry there.