On Thu, 6 Dec 2001 23:07:13 +0200 "Vins" <[EMAIL PROTECTED]> wrote:
> The code is supposed to look like this... > (Example of code only) > ____________________________________ > > <?php > > $dbc = mysql_connect("host", "un", "pwd") or die ("Failed Connecting to > Database"); > @mysql_select_db("dbname") or die ("Failed to Select Databse"); > > $query = "Select name, surname, email from users"; > $result = mysql_query($query) or die ("Failed to Query Database"); > > if(isset($result)) { > $i = 1; > > while($row = mysql_fetch_array($result)) { > $name = $row["name"]; > $surname = $row["surname"]; > $email = $row["email"]; > > if(ereg("1$|3$|5$|7$|9$", $i)) { > $bg[$i] = "#FFFFFF"; > } else { > $bg[$i] = "#CCCCCC"; > } > > echo "<TR BGCOLOR=\"".$bg[$i]."\">\n"; > echo "<TD>".$name."</TD>\n"; > echo "<TD>".$surname."</TD>\n"; > echo "<TD>".$email."</TD>\n"; > echo "</TR>\n"; > > $i++; > } > } $aBgColors = array("#999999","#FFFFFF"); while(whateveryouwant){ $i = $iCpt++ % 2; echo "<TR BGCOLOR=\"".$bg[$i]."\">\n"; } or more generally with css $aBgColors = array("evenrow","oddrow"); while(whateveryouwant){ $i = $iCpt++ % 2; echo "<TR CLASS=\"".$bg[$i]."\">\n"; } hth pa -- Pierre-Alain Joye Freelance Developpements et Services web/intranet [EMAIL PROTECTED] -- 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]