Hi,
Does anyone know of a function in php that will return the day in text format (Monday etc.) from a date stored in a mysql table as type DATE? I think i am clutching at straws as many people have written custom php scripts for this..
Help?
Andy.
no php function on offer (though it's certainly possibly with php), I'd always let mysql do this:
SELECT DATE_FORMAT(colname, '%W') AS weekday, ...
see http://dev.mysql.com/doc/mysql/en/Date_and_time_functions.html