[ Closed ] Displaying results

<?php 
    // query to set up appropriate player challenges
    $query = "SELECT * FROM punbb2_ladders WHERE imatch_id=$imatch_id";
    $result = mysql_query($query) or die('Query failed: ' . mysql_error());
    $imatch_id = (int)$_GET['imatch_id'];
                    
?>
<br />
<?php echo $line['username'].'\'s pending challenges:' ?></dt><br />
<?php 
    while ($row = mysql_fetch_array($result, MYSQL_ASSOC))
    { if ($row['playerb'] == $line['username']) { echo $row['playera'].'has a challenge against'.$row['playerb'].'(awaiting winner)'; 
    } else     { echo 'No current challenges'; }
}
?>