Hey there,
ive got this SQL, and it works. But i get a - before each number! Its just so i can see members who have been inactive for over xx days.
SELECT ipals_members.m_name, ipals_members.m_email, ipals_members.m_username, ipals_members.m_last_logged, ipals_profile.p_id, ipals_profile.m_id, TO_DAYS(m_last_logged)-TO_DAYS(NOW()) as no_days
FROM ipals_members LEFT JOIN ipals_profile ON ipals_members.m_id = ipals_profile.m_id
WHERE DATE_ADD(m_last_logged, INTERVAL 15 DAY) <= NOW() AND ipals_members.m_id = ipals_profile.m_id
ORDER BY ipals_members.m_last_logged ASC
it does it right like i said, but echos:
Last Logged in: -24 Days Ago
would like it without the - if anyone has any idea!??!
Thanks in advance!
Danny
