[SOLVED] Help with date/time data from mysql

[Darkmatter5]

I have a datetime item in a table of my database.  If it has no value or is set to "0000-00-00 00:00:00", how can I check if it's all zeros or has an actual date assigned to it?  I tried is_null(), but it didn't work.

 

Any help is appreciated!

[flyhoney]

I imagine you can just do something like this:

 

<?php
$query = "SELECT name FROM birthdays WHERE datetime > '0000-00-00 00:00:00'";
$result = mysql_query($query);
while ($row = mysql_fetch_object($result)
{
    echo $row->name.'<br />';
}
?>

[Darkmatter5]

Worked thanks!