mysql numrows error in query..

[crawfd]

I'm getting a mysql numrows error for each of my three queries below, and then a headers sent error, but I think the mysql numrows sql error is causing the headers sent error. I can't seem to find the problem..

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]; 
    $last = $a1['llogin']; 




//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>"; 



//explode date
$i = explode("/", $a1[date]);

//find age
$ageTime = mktime(0, 0, 0, $i[0], $i[1], $i[2]); // Get the person's birthday timestamp
$t = time(); // Store current time for consistency
$age = ($ageTime < 0) ? ( $t + ($ageTime * -1) ) : $t - $ageTime;
$year = 60 * 60 * 24 * 365;
$ageYears = $age / $year;

$qllogin = "update class_members set llogin = '".Date("Y-m-d H:i:s")."', age = '".floor($ageYears)."' where MemberID = '".$_SESSION[MemberID]."'";
mysql_query($qllogin);


//echo ''.mysql_num_rows($f5).'<br>';
//die();



if(!empty($_POST[url])) {

header("Location: ".urldecode($_POST['url']));
exit(); 

}


	//header("location:usr/member.php?id=$_SESSION[MemberID]");

	header("location:invite.php?id=$_SESSION[MemberID]&$message");



	exit();


}
else
{

	$error2 = "<font face=verdana color=red size=2><b>Invalid username/password!</b></font>";
}

require_once("bling/includes.php");

}

[NogDog]

What error message do you get?

My guess is that your queries are failing. Instead of coding with the assumption that things will work, you should code "defensively" with the assumption that things will fail. Instead of doing:

if(mysql_num_rows(mysql_query($SQL))>0){     

$message = "pcomments=true&";
}

Do something like:

$result = mysql_query($SQL);
if($result)
{
   if(mysql_num_rows($result) > 0)
   {
      $message = "pcomments=true&";
   }
}
else
{
   user_error("Query failed: " . mysql_error() . "<br />$SQL");
   // output error to user, or die() or whatever....
}