Hi People,
I have a sql query running an array'd result that should echo a different
result depending on the result of the query. However, it successfully does
one of the entries from the query, but then appears to stop. With no further
results displayed. Could someone take a look at the code at the bottom of
this email and see if they can determine why it is not continuing through
the rest of the results.
Thanks in advance
- Shannon
<?
$roundnum = "";
$sql = "select * from results order by round";
$dbh = @mysql_connect($dbhost,$dbuser,$dbpass);
$results = mysql_db_query($db,$sql,$dbh);
for($i = 0; $i < mysql_num_rows($results); $i++) {
$array[$i] = mysql_fetch_array($results);
}
mysql_close($dbh);
for ($i = 0; $i < count($array); $i++) {
if ($array[$i]["round"] != $roundnum) {
$roundnum = $array[$i]["round"];
echo "<tr><td colspan='5'><br><p align='center'><b><font
color='#990000'>Round ".$roundnum."</font></b></p></td></tr>";
echo "<tr><td width='100'><p>".$array[$i]["home"]."</p></td><td
width='10'><p>".$array[$i]["home_goals"]."</p></td><td width='50'>\n";
if ($array[$i]["home_goals"] > $array[$i]["away_goals"]) {
echo "<p>Defeated</p></td>";
}
elseif ($array[$i]["home_goals"] < $array[$i]["away_goals"]) {
echo "<p>Defeated by</p></td>";
}
elseif ($array[$i]["home_goals"] == $array[$i]["away_goals"]) {
echo "<p>Drew</p></td>";
}
echo "<td width='100'><p>".$array[$i]["away"]."</p></td><td
width='10'><p>".$array[$i]["away_goals"]."</p></td>\n";
}
}
?>
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
