Hi,

i have the following snippet of php that i wrote but cant figure out why it wont work all the variables have been set before hand.

Heres the PHP:

PHP Code:

echo "<table border='1'> 
<tr>"; 
if ($win_score > $lose_score) { 
echo " 
<th>Winner</th> 
<th>Loser</th> 
<th>Win Score</th> 
<th>Lose Score</th> 
</tr>"; 

while($row = mysql_fetch_array($result)) 
  { 
  echo "<tr>"; 
  echo "<td>" . $row['winner'] . "</td>"; 
  echo "<td>" . $row['loser'] . "</td>"; 
  echo "<td>" . $row['win_points'] . "</td>"; 
  echo "<td>" . $row['lose_points'] . "</td>"; 
  echo "</tr>"; 
  } 
echo "</table>";
} 


And "won't work" means??

Sorry i should of explained it better.

When $win_score value is greater than $lose_score value its meant to display a table with some data in it but it just displays an empty table with the column headers.

It looks fine to me

does it close the table?

does it print any cells at all?

The only cells it displays are the top ones that have the heading titles in them.

In that case it seems like your sql query is not returning any rows.