PHP - MYSQL help. pull info from 2 tables

[flemingmike]

hi, i need help with a code.  i thought this would work:

 

$compare=mysql_query("SELECT ladderid,teamid FROM membersteam WHERE memberid='{$_COOKIE['user']}'");

 

and

 

$totalchall=mysql_query("SELECT COUNT(*) FROM challenges WHERE challgrid='$compare[id]' OR challgdid='$compare[id]'");
$totalchall=mysql_fetch_array($totalchall);
$totalchall="$totalchall[0]";

if($totalchall == 0){
$out[body].="<tr bgcolor='$config[altcolora]'>
<td width='100%' valign='center' align='center' colspan='5' background='$config[cellbg]'>No outstandings challenges.</td></tr>";
}else{
$challenges=mysql_query("SELECT challid,challgrid,challgdid,challgrname,challgdname,DATE_FORMAT(created,'%M %d at %l:%i %p') FROM challenges WHERE challgrid='$compare[id]' OR challgdid='$compare[id]' ORDER BY created DESC");
while(list($challid,$challgrid,$challgdid,$challgrname,$challgdname,$created)=mysql_fetch_row($challenges)){

[flemingmike]

maybe this makes more sence... ?

 

$totalchall=mysql_query("SELECT COUNT(*) FROM challenges WHERE challgrid,ladderid='$compare[teamid,ladderid]' OR challgdid,ladderid='$compare[teamid,ladderid]'");
$totalchall=mysql_fetch_array($totalchall);
$totalchall="$totalchall[0]";

if($totalchall == 0){
$out[body].="<tr bgcolor='$config[altcolora]'>
<td width='100%' valign='center' align='center' colspan='5' background='$config[cellbg]'>No outstandings challenges.</td></tr>";
}else{
$challenges=mysql_query("SELECT challid,ladderid,challgrid,challgdid,challgrname,challgdname,DATE_FORMAT(created,'%M %d at %l:%i %p') FROM challenges WHERE challgrid,ladderid='$compare[teamid,ladderid]' OR challgdid,ladderid='$compare[teamid,ladderid]' ORDER BY created DESC");
while(list($challid,$ladderid,$challgrid,$challgdid,$challgrname,$challgdname,$created)=mysql_fetch_row($challenges)){