Date Difference in mySQL not returning any data

[thaphantom]

Ok when I run the following it should be giving me the difference in joinDate and the CURRENT_DATE in years. Yet I am not getting any veriables returned. I ran it in phpMyAdmin and it gave 3 variables in an aray, the joinDate, the CURRENT_DATE, the diff in years. To me this means I should be able to just use $years_in_aat[2] and get the # of years. Yet there is nothing at all in $years_in_aat[0], $years_in_aat[1], $years_in_aat[2]. When I just display $years_in_aat I get Resource id #4...

Any help would be greatly appreciated

$years_in_aat = mysql_query ( "SELECT joinDate, CURRENT_DATE, (YEAR(CURRENT_DATE)-YEAR(joinDate)) - (RIGHT(CURRENT_DATE,5)<RIGHT(joinDate,5)) FROM members AS age WHERE ID = $mem_ID") or die ("Invalid query");

[nnichols]

"mysql_query()" returns a resource id (a link to the result set). To use the data returned you have to fetch it using one of the following _fetch_fns -

mysql_fetch_row($years_in_aat);
mysql_fetch_array($years_in_aat);
mysql_fetch_assoc($years_in_aat);
mysql_fetch_object($years_in_aat);

You could use something like this -

$sql = "SELECT joinDate, CURRENT_DATE, (YEAR(CURRENT_DATE)-YEAR(joinDate)) - (RIGHT(CURRENT_DATE,5)<RIGHT(joinDate,5))
FROM members AS age 
WHERE ID = $mem_ID";
$result = mysql_query ($sql )
    or die ("Invalid query");
if (mysql_num_rows($result)==1) {
    $row=mysql_fetch_row($result);
    $age = $row[2];
    }

Hope this helps 😉