php print different color in rows

Question

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++;
    }

I'm so sorry I have to put this here, but could not resist - this is pretty much the Fizz Buzz question — Duniyadnd
– Duniyadnd, Commented Dec 15, 2012 at 3:27
You can do this with just css plus inline css is bad practice, as well as using <b>. — elclanrs
– elclanrs, Commented Dec 15, 2012 at 3:37

christopher · Accepted Answer · 2012-12-15 03:27:47Z

4

$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++;
    }

answered Dec 15, 2012 at 3:27

christopher

6435 silver badges12 bronze badges

Sign up to request clarification or add additional context in comments.

4 Comments

Justin John Over a year ago

How $start&1 works here? Whether it should take all odd ones?

christopher Over a year ago

@Justin no clue. It just does. Couldn't find any documentation anywhere

Duniyadnd Over a year ago

It's a bitwise operator via another question

christopher Over a year ago

Yeah but I can't find in the PHP.net documentation. I found this: php.net/manual/en/language.operators.bitwise.php, but it doesn't seem to describe this behavior.

Collectives™ on Stack Overflow

php print different color in rows

1 Answer 1

4 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

4 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related