In some scripts i found, im trying to recreate them, heres my problem.
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:
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.
Days Since Login: 0
Days in Clan: 12917
<?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...