date function

["Darryl" <darryl@osborne-ind.com>]

Greetings,
I have some php code that pulls from the mysql database.  Here it is:

<?php
         mysql_connect("wildcat.osborneindustries.com", "webuser",
"webpass");
   $mymonth = date('n');
   $cyear = date('Y');
         $query = "SELECT name,hdate FROM emp2 where month(hdate)=$mymonth
order by hdate";
         $result = mysql_db_query("iweb", $query);

         if ($result) {
           echo "<table align=center  border=0  cellspacing=5 >";
           while ($r = mysql_fetch_array($result)) {
              $name = $r["name"];
     $hyear = date('Y',$r["hdate"]);
     $timein = $cyear - $hyear;
     if ($timein > 0) {
                echo
"<tr><td>$name</t><td>$timein</td><td>$cyear</td><td>$hyear</td></tr>";}
           }
           echo "</table>";
         } else {
        echo "No data.";
    }
    mysql_free_result($result); ?>

I'm trying to figure out years of employment based on hiredate.  Its not
working as expected.  $timein is always
1969.  Date in the database is YYYY-MM-DD.  What have I screwed up ?

thanks,
Darryl

-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php