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]

Reply via email to