SQL Query

[NZ_Kiwi]

Hi have the below code.. it's pre-written for me... nothing displays... does anyone know why?

<?php

// Viewing // 
$result = mysql_query ("select r.result_id, r.team1_id, t1.team_id,r.team2_id,t2.team_id,r.team1_score,r.team2_score, r.game_played from results_data as r left join results_comp_run_teams as t1 on (r.team1_id = t1.team_id) left join results_comp_run_teams as t2 on (r.team2_id = t2.team_id) where r.group_id = $list_group and r.comp_run_id = $comp_run_id order by r.list_order");

if ($result == "")
{
?>

<font face="Arial" size="2" color="#000000"><br>No games added for this group</font><br>
<?php
} else {
while ($row = mysql_fetch_array($result))
{  

if ($row["game_played"] == 0)
{
?>

<font face="Verdana,Arial" size="2" color="#000000">
<?php echo $row[2]; ?></font> <font face="arial" size="2" color="black">vs</font>

<font face="Verdana,Arial" size="2" color="#000000"><?php echo $row[4]; ?></font>
<font face="Verdana" size="1">

[<a href="addinfo.php?comp_id=<?php echo $comp_id; ?>&result_id=<?php echo $row["result_id"]; ?>">add/edit details</a>] [<a href="addinfo2.php?result_id=<?php echo $row["result_id"]; ?>&comp_id=<?php echo $comp_id; ?>" onClick="return popUp('addinfo2.php?comp_id=<?php echo $comp_id; ?>&result_id=<?php echo $row["result_id"]; ?>', 'imageName','width=350,height=150,resizable=yes')">add score only</a>]
</font><br>

<?php
} else {
?>

<font face="Verdana,Arial" size="2" color="#000000">
<?php echo $row[2]; ?></font> <b><font face="Verdana,Arial" size="2" color="#800000"><?php echo $row["team1_score"]; ?></font></b> 

<font face="arial" size="2" color="black">vs</font>

<font face="Verdana,Arial" size="2" color="#000000">
<?php echo $row[4]; ?></font> <b><font face="Verdana,Arial" size="2" color="#800000"><?php echo $row["team2_score"]; ?></font></b> <font face="Verdana" size="1">

[<a href="addinfo.php?comp_id=<?php echo $comp_id; ?>&result_id=<?php echo $row["result_id"]; ?>">add/edit details</a>] [<a href="addinfo2.php?result_id=<?php echo $row["result_id"]; ?>&comp_id=<?php echo $comp_id; ?>" onClick="return popUp('addinfo2.php?comp_id=<?php echo $comp_id; ?>&result_id=<?php echo $row["result_id"]; ?>', 'imageName','width=350,height=150,resizable=yes')">add score only</a>]</font><br>

<?php
}
};
?>

[NZ_Kiwi]

also what is the $row[2] i think this could be it??

[robert_w_ark]

add or die(mysql_error()); at the end of the statement, maybe theres a warning somewhere o,0

[NZ_Kiwi]

Originally posted by robert_w_ark
add or die(mysql_error()); at the end of the statement, maybe theres a warning somewhere o,0

Like this

$result = mysql_query ("select r.result_id, r.team1_id, t1.team_id,r.team2_id,t2.team_id,r.team1_score,r.team2_score, r.game_played from results_data as r left join results_comp_run_teams as t1 on (r.team1_id = t1.team_id) left join results_comp_run_teams as t2 on (r.team2_id = t2.team_id) where r.group_id = $list_group and r.comp_run_id = $comp_run_id order by r.list_order") or die(mysql_error()); 

Because I get this error
You have an error in your SQL syntax near 'and r.comp_run_id = 1 order by r.list_order' at line 1