//$timestamp = strtotime('2006-01-10 16:09:30');
I want to convert usrcomments.dateadd below (e.g. coming in from my db in the format of 2006-01-10 16:09:30 at the moment) in my query statement to a timestamp. I want to do it directly in the query statement though, ...confused about the formatting of it. I have class_members.llogin already in the form of a timestamp in my db so I need to convert usrcomments.dateadd to a timestamp as well.
$SQL= "SELECT usrcomments.dateadd, usrcomments.MemberID, class_members.llogin, class_members.MemberID FROM usrcomments, class_members where usrcomments.MemberID = class_members.MemberID and usrcomments.profid = '$_GET[id]' AND usrcomments.dateadd > class_members.llogin)";
if(mysql_num_rows(mysql_query($SQL))>0){
echo 'You have new messages!';
}
