Alt. Row Color... dosnt alt.

[erikhillis]

Hey, I'm wondering why my alternate row color isnt alternating... could someone pls tell me whats wrong and fix it up? 🙂

<?php 

// Database Connection 
$db = mysql_connect("localhost","db_un","pw");
mysql_select_db (db);

if(!isset($_GET['page'])){
    $page = 1; 
} else { 
    $page = $_GET['page']; 
} 

$max_results = 20; 

$from = (($page * $max_results) - $max_results); 

$sql = "SELECT * FROM maps WHERE game='{$_REQUEST['game']}' ORDER BY name asc LIMIT $from, $max_results"; 
if (!$result = mysql_query($sql)) {   

    print "Invalid query ($sql) : " . mysql_error();   

    exit;   

}

$num = mysql_num_rows($result);  

if ($num < 1) {   

echo "<div align=left><font color=#FFFFFF face=Verdana size=1>Sorry, there are <B>0</B> Maps in this category.<br>";   

}    

else    

{
while($row = mysql_fetch_array($result)) { 

$bcolor = false;

print "<table width=100% cellpadding=2 cellspacing=0>";

echo "<tr bgcolor=\"". ($bcolor = !$bcolor ? '#354255' : '#2F3948' ) . "\">
<td width=1% valign=top><img src=".$row["screenshot"]." width=70 height=55></td>
<td width=99% valign=top><font face=Verdana size=1 color=7c8893><B>»&nbsp;</B><font face=Verdana size=1 color=FFFFFF><a href=map.php?id=".$row["id"]."><B>".$row["name"]."</a></B><br><br>
<B>Game Types:</B><font color=#7c8893> ".$row["gametype"]." <font color=#FFFFFF><B>Creator:</B><font color=#7c8893> ".$row["creator"]." <font color=#FFFFFF><br>This map has been downloaded <B>".$row["hits"]."</B> times.<br></td></tr>";

print "</table>";

 }
}

$total_results = mysql_result(mysql_query("SELECT COUNT(*) as Num FROM maps WHERE game='{$_REQUEST['game']}'"),0); 

$total_pages = ceil($total_results / $max_results); 

echo "<font face=Verdana size=1 color=#FFFFFF><br><B>Select a Page</B><br />"; 

if($page > 1){ 
    $prev = ($page - 1); 
    echo "<a href=\"?page=$prev\"><font face=Verdana size=1 color=#7c8893><B>«</B><Previous</a>&nbsp;"; 
} 

for($i = 1; $i <= $total_pages; $i++){ 
    if(($page) == $i){ 
        echo "$i&nbsp;"; 
        } else { 
            echo "<a href=\"?page=$i\">$i</a>&nbsp;"; 
    } 
} 

if($page < $total_pages){ 
    $next = ($page + 1); 
    echo "<a href=\"?page=$next\">Next&nbsp;<font face=Verdana size=1 color=#7c8893><B>»</B></a>"; 
} 
echo ""; 
?>

[hoax_monkey]

See if this works:

$bcolor = '#354255';

while($row = mysql_fetch_array($result)) {  

    $bcolor = ($bg=='#354255' ? '#2F3948' : '#354255');
        echo "<table width=100% cellpadding=2 cellspacing=0>"; 

echo "<tr bgcolor=\", $bcolor, \"> 
<td width=1% valign=top><img src=".$row["screenshot"]." width=70 height=55></td> 
</tr>\n ";
}