Unixtimestamp question

[AC_Drkan]

In some scripts i found, im trying to recreate them, heres my problem.

Code Select Expand

SELECT TO_DAYS(NOW())-TO_DAYS(FROM_UNIXTIME(logindate)) FROM members WHERE id = $mid

im trying to figure out what to set logindats as in phpmyadmin. So far i have tried everything and have been unsuccessful. So my question is, i know what NOW() returns, and have tried to make it similar to logindate, but i can't seem to figure out this FROM_UNIXTIME function. If someone could help me out, it would be muchly appreciated.

It produces this:

Code Select Expand


Days Since Login: 13148
Days in Clan: 12916

I just got the scripts able to login yesterday, and im sure i have all the correct tables.


EDIT:
I found the error, the table just need to be listed as an int with 15 values, and somehow it works.

Code Select Expand


Days Since Login: 0
Days in Clan:            12917

[rabbit]

Code Select Expand

<?php    list($y_check, $m_check, $d_check) = split('[-]', $row['last_login']);    $y = date("Y");    $m = date("m");    $d = date("d");    $control = mktime(0, 0, 0, $m, $d, $y);    $check = mktime(0, 0, 0, $m_check, $d_check, $y_check);    $difference = $control - $check;    $dsl = floor($difference / 60 / 60 / 24);?>

At least...that's how I do it...