[SOLVED] Date Question

[JSHINER]

function getTodayCheck($db, $id_user = false) {
$today = date('y-m-d');
return $db->getArray("SELECT * FROM quizzes_taken WHERE id_user = '$id_user' AND date_quiz = '$today'");
}

$page['todayCheck'] = getTodayCheck($db, $_SESSION['id_user']);

if($page['todayCheck']) { echo 'You took a quiz today!'; }

 

The date_quiz is stored as 2008-05-15 11:17:48

 

But the $today is 2008-05-15 - how can I get them to interact nicely.

 

Do I have to change the way it's stored in the database?

[BlueSkyIS]

if you don't need the time, it would be simpler to store the date as a DATE instead of DATETIME. if you don't want to change data types, you could simply append 00:00:01 or something on the end of $today before you store it.

[JSHINER]

$today isn't being stored it's being compared to the stored date_quiz to see if they have taken a quiz today.

[BlueSkyIS]

ok. if you don't want to change the field type, you could explode(" ",$dbdate) the value stored in the database and use the first part, which will be just the date:

 

$ddate = $dateinthedatabase;
$ddate_parts = explode(" ",$ddate);
$date_without_time = $ddate_parts[0];

 

[PFMaBiSmAd]

To just use or return the DATE portion of a DATETIME, use the msyql DATE() function in your query -

 

DATE(expr)

 

Extracts the date part of the date or datetime expression expr.

mysql> SELECT DATE('2003-12-31 01:02:03');

        -> '2003-12-31'

[JSHINER]

What I need to do is compare the "2008-05-15" part of each to determine if they're the same.

[PFMaBiSmAd]

Mysql also has a current date function - CURDATE(), so your function can be simply written as -

 

function getTodayCheck($db, $id_user = false) {
return $db->getArray("SELECT * FROM quizzes_taken WHERE id_user = '$id_user' AND DATE(date_quiz) = CURDATE()");
}

[The Little Guy]

How many records do you have in your database?  If you don't have many, I would recommend changing them to a UNIX TIME STAMP