Trying to use the $last variable and include it in my 3 query statements below. When I echo out the queries it's blank after the '>' so I'm assuming it's not reading the variable $last correctly? All dates in my tables are in the datetime format 0000-00-00 00:00:00.
Attempting to check for new messages after last login, $last varialbe being the llogin time in the table.
//If logging in as a user
if(isset($_POST[s2]))
{
$url = $_POST[url];
$q1 = "select * from class_members where username = '$_POST[us]' and password = '$_POST[ps]' ";
$r1 = mysql_query($q1) or die(mysql_error());
if(mysql_num_rows($r1) == '1')
{
//ok
$a1 = mysql_fetch_array($r1);
$_SESSION[MemberID] = $a1[MemberID];
$a1[llogin] = $last;
//new profile comments
$SQL= "SELECT usrcomments.MemberID, usrcomments.id, class_members.llogin, class_members.MemberID, usrcomments.dateadd FROM usrcomments, class_members where usrcomments.MemberID = class_members.MemberID and usrcomments.profid = ".$a1[MemberID]."
AND usrcomments.dateadd > '$last'";
if(mysql_num_rows(mysql_query($SQL))>0){
$message = "pcomments=true&";
}
//new blog comments
$SQL2= "SELECT usrcomments.MemberID, usrcomments.id, usrcomments.oid, usrcomments.id, class_members.MemberID, class_members.llogin, usrcomments.dateadd, usrcomments.sect from usrcomments, class_members, blog where usrcomments.MemberID = class_members.MemberID AND usrcomments.sect = blog.id and usrcomments.oid = ".$a1[MemberID]."
AND usrcomments.dateadd > '$last'";
if(mysql_num_rows(mysql_query($SQL2))>0){
$message .= "bcomments=true&";
}
//pending connections
$SQL3= "SELECT connections.usr, class_members.llogin, class_members.MemberID, connections.connection, connections.id, connections.status, connections.dateadd, class_members.MemberID from connections, class_members where connections.usr = class_members.MemberID AND connections.connection = ".$a1[MemberID]." AND connections.dateadd > '$last'";
if(mysql_num_rows(mysql_query($SQL3))>0){
$message .= "connections=true";
}
echo "mysql_query($SQL)<br>";
echo "mysql_query($SQL2)<br>";
//echo "$message<br>";
