I'm trying to check for comments written after a login, and if so echo a variable.
I don't believe I have both date formats in synch though. The llogin field below is in the format of '1176163100' in my db, while the field dateadd is in the form of '2006-11-26 05:01:22'. I thought by adding a unix timestamp to the field 'dateadd', it would format it to the similar timestamp but I don't think it is because it's not comparing the dates right.
$SQL= "SELECT UNIX_TIMESTAMP(usrcomments.dateadd),
usrcomments.MemberID, class_members.llogin,
class_members.MemberID FROM usrcomments, class_members where
usrcomments.MemberID = class_members.MemberID and
usrcomments.profid = '$a1[MemberID]' AND usrcomments.dateadd > llogin";
if(mysql_num_rows(mysql_query($SQL))>0){
$m = "profile=true&";
}