Date & MySQL

[Pete_Bekisz]

Hi,

In my database, I store dates in this method:

yyyymmdd

Can anyone help me write this properly?

if ($D1 == "month") {
$get = "WHERE date substr(4,-2) = '$month'";
}

$q = mysql_query("SELECT * FROM chat_feedback $get ORDER BY $sort");

Thanks in advance.

[cgraz]

If you just want to get the month from your date field, use this

$q = mysql_query("SELECT MONTH(date) AS M FROM chat_feedback ORDER BY $sort") or die(mysql_error());

More on date and time functions here: http://www.mysql.com/doc/en/Date_and_time_functions.html

Cgraz