CODEWITHSUNDEEP
php
Benjamin W
Benjamin W

Reputation: 2848

php print different color in rows

I try to print out all user email from table, but i want odd number print in red even number print in blue. how to do this in while loop?

$connect=mysql_connect("localhost", "root", "");
$database=mysql_select_db("phplogin", $connect);

$SQL=mysql_query("SELECT * FROM users");
$num=mysql_num_rows($SQL);
$start=0;

while($start<$num){
    $result_id=mysql_result($SQL, $start, "id");
    $result_email=mysql_result($SQL, $start, "email");

    echo "<b style='color:red'>" . $result_id . $result_email . "</b><br/>";
    echo "<b style='color:blue'>" . $result_id . $result_email . "</b><br/>";

    $start++;
    }

Upvotes: 0

Views: 140

Answers (1)

christopher
christopher

Reputation: 643

$connect=mysql_connect("localhost", "root", "");
$database=mysql_select_db("phplogin", $connect);

$SQL=mysql_query("SELECT * FROM users");
$num=mysql_num_rows($SQL);
$start=0;

while($start<$num){
    $result_id=mysql_result($SQL, $start, "id");
    $result_email=mysql_result($SQL, $start, "email");
    if ($start&1) {
      echo "<b style='color:red'>" . $result_id . $result_email . "</b><br/>";
    }
    else {
      echo "<b style='color:blue'>" . $result_id . $result_email . "</b><br/>";
    }
    $start++;
    }

Upvotes: 4

Related Questions