php-mysql not working pulling data - thanks in advance

[flemingmike]

here is my code:

 

<?


include("./includes/incglobal.php");




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


$team=mysql_query("SELECT * FROM teams WHERE id='$comare'");
$team=mysql_fetch_array($team);



$ladder=mysql_query("SELECT name,isteam FROM ladders WHERE id='$team[ladderid]'");
$ladder=mysql_fetch_array($ladder);



$out[body].="";


$out[body].="
<tr>
  <td width='100%'><img src='./images/stats/spacer.gif' border='0' /><br /><table width='94%' border='0' cellspacing='1' cellpadding='2' bgcolor='#000000'>
<tr bgcolor='$config[altcolora]'>

</tr>
</table></td>
</tr>
</table></td></tr></table>
<br />
<div align='center'>";



$out[body].="";

$members=mysql_query("SELECT memberid,position,joined,DATE_FORMAT(joined,'%M %d, %Y') FROM membersteams WHERE teamid='$team[id]' ORDER BY position");
while(list($memberid,$position,$joined,$date)=mysql_fetch_row($members)){
$mem=mysql_query("SELECT * FROM members WHERE id='$memberid'");
$mem=mysql_fetch_array($mem);


}







$out[body].="
</table><br>
<script type='text/javascript'>
  <!--
    function Challenge( id, login ) {
      window.open('./scheduler.php?chall_id='+id + 'login[id2]='+login, '_details', 'width=600,height=500,toolbar=0,statusbar=0,scrollbars=0,menubar=0');
    }
  //-->
  </script>
<table width='95%' border='0' cellspacing='1' cellpadding='2' bgcolor='#000000'>
<tr bgcolor='$config[altcolora]'>
<td width='100%' valign='center'  background='$config[bg]' align='left' colspan='5'><b>  Challenges</b></td>
</tr>
<tr bgcolor='$config[altcolorb]'>
<td width='5%' valign='center'  background='$config[bg2]' align='center'><b>ID</b></td>
<td width='5%' valign='center'  background='$config[bg2]' align='center'><b></b></td>
<td width='30%' valign='center' background='$config[bg2]' align='center'><b>Challenger</b></td>
<td width='30%' valign='center'  background='$config[bg2]' align='center'><b>Challenged</b></td>
<td width='30%' valign='center'  background='$config[bg2]' align='center'><b>Date</b></td>
</tr>";

$totalchall=mysql_query("SELECT COUNT(*) FROM challenges WHERE challgrid='$team[id]' OR challgdid='$team[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='$team[id]' OR challgdid='$team[id]' ORDER BY created DESC");
while(list($challid,$challgrid,$challgdid,$challgrname,$challgdname,$created)=mysql_fetch_row($challenges)){

$check=mysql_query("SELECT * FROM chall_chat WHERE chall_id='$challid'");
$check=mysql_fetch_array($check);

if ($check[ed_status]==Accepted OR $check[er_status]==Accepted){
$msg = "<span style=\'color:red\'><center><strong>Both Teams have Accepted the Match Date!</strong></center></span><br /> <span style=\'color:black;font-weight:bold;\'>Match Details:</span><br />        <strong>Date:</strong> $check[month] $check[day], $check[year]<br />        <strong>Time:</strong> $check[hour]:$check[min] $check[ampm] $check[zone] <br />        <strong>Server:</strong> $check[server]<br />        <strong>Game Name:</strong> $check[game]";
$hover = "<a href='javascript: void Challenge($challid,$team[id])' onmouseover=\"return overlib('$msg', HEIGHT, 60, WIDTH, 260, CAPTION, '<span style=\'color:blue;\'>Current Challenge Status</span>');\" onmouseout=\"return nd();\">";
$calendarimg = "$hover<img src='./images/calendar2.gif' border='0'></a>";
}elseif ($check[ed_status]==Declined OR $check[er_status]==Declined){
$msg = "<center>The Challenge has been Declined.</center>";
$hover = "<a href='javascript: void Challenge($challid,$team[id])' onmouseover=\"return overlib('$msg', CAPTION, '<span style=\'color:blue;\'>Current Challenge Status</span>');\" onmouseout=\"return nd();\">";
$calendarimg = "$hover<img src='./images/calendar3.gif' border='0'></a>";
}elseif ($check[ed_status]==Pending OR $check[er_status]==Pending){
$msg = "<center>This Challenge is Pending Approval.</center>";
$hover = "<a href='javascript: void Challenge($challid,$team[id])' onmouseover=\"return overlib('$msg', CAPTION, '<span style=\'color:blue;\'>Current Challenge Status</span>');\" onmouseout=\"return nd();\">";
$calendarimg = "$hover<img src='./images/calendar.gif' border='0'></a>";
}else{
$msg = "<center>No Suggestions have been made.</center>";
$hover = "<a href='javascript: void Challenge($challid,$team[id])' onmouseover=\"return overlib('$msg', CAPTION, '<span style=\'color:blue;\'>Current Challenge Status</span>');\" onmouseout=\"return nd();\">";
$calendarimg = "$hover<img src='./images/calendar1.gif' border='0'></a>"; }

if($config[altcolorx]==$config[altcolora]){
$config[altcolorx]="$config[altcolorb]";
}else{
$config[altcolorx]="$config[altcolora]";
}
if($config[cellbgx]==$config[cellbg]){$config[cellbgx]="$config[cellbg2]";}else{$config[cellbgx]="$config[cellbg]";}

$out[body].="
<tr bgcolor='$config[altcolorx]'>
<td width='5%' valign='center' align='center' background='$config[cellbgx]'>$challid</td>
<td width='5%' valign='center' align='center' background='$config[cellbgx]'>$calendarimg</td>
<td width='30%' valign='center' align='center' background='$config[cellbgx]'><a href='$config[scripturl]/stats.php?account=$challgrid'>$challgrname ($challgrid)</a></td>
<td width='30%' valign='center' align='center' background='$config[cellbgx]'><a href='$config[scripturl]/stats.php?account=$challgdid'> $challgdname ($challgdid)</a></td>
<td width='30%' valign='center' align='center' background='$config[cellbgx]'> $created</td>
</tr>";
}
}



$out[body].="
</table>
<br />
</div>";

include("$config[html]");
?>

 

when i load the page, i get the meggage:

 

No outstandings challenges.

 

any ideas where the code lost track?

 

 

[trq]

Again, $compare is an array....

 

$compare=mysql_fetch_array($compare);

 

And you attempt to use it in your query which expects a string....

 

$team=mysql_query("SELECT * FROM teams WHERE id='$comare'");

 

Note also the spelling error.

 

Besides these facts, Id suggest you take a look at using joins in your queries.