PHP: apply CSS to every second row [duplicate]

Question

Possible Duplicate:
How to set alternate row color for an iterated table in php?
Using CSS :even and :odd pseudo-classes with list items

I have a html table populated with data from a mysql table. I use the following code:

$result = mysql_query("SELECT * FROM {$table}");
if (!$result) {
die("Query to show fields from table failed");
}

$fields_num = mysql_num_fields($result);

echo "<h1>Table: {$table}</h1>";
echo "<tr>";

echo "</tr>\n";

while($row = mysql_fetch_row($result))
{
echo "<tr>";

foreach($row as $cell)
    echo "<td>$cell</td>";

echo "</tr>\n";
}
mysql_free_result($result);

Note: I normally use PDO statments but for this example i use mysql.

The code generate the table correctly. The question is: I want to apply a CSS to every second row with the following class=table_higlight. How can I do this?

:even and :odd have a poor browser compatibility...

Florent
– Florent

2012-09-03 17:02:56 +00:00
Commented Sep 3, 2012 at 17:02 — Florent
– Florent, Commented Sep 3, 2012 at 17:02

JvdBerg · Accepted Answer · 2012-09-03 17:06:50Z

5

Use:

$i = 0;
while($row = mysql_fetch_row($result)) {
  if ($i % 2 == 0 )
    echo '<tr class="even">';
  else
    echo '<tr class="odd">';

  foreach($row as $cell)
    echo "<td>$cell</td>";

  echo "</tr>\n";
  $i++
}

answered Sep 3, 2012 at 17:06

JvdBerg

21.8k8 gold badges40 silver badges55 bronze badges

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

1 Comment

user466764 Over a year ago

Why not just use css pseudo selectors eg. tr:odd or tr:even ?

rationalboss · Accepted Answer · 2012-09-03 17:01:37Z

1

while($row = mysql_fetch_row($result))
{
echo "<tr".(++$ctr%2 == 0 ? ' class="table_highlight"' : '').">";

foreach($row as $cell)
    echo "<td>$cell</td>";

echo "</tr>\n";
}

answered Sep 3, 2012 at 17:01

rationalboss

5,3973 gold badges32 silver badges50 bronze badges

2 Comments

rationalboss Over a year ago

Why? foreach ($row as $cell) should list each column in the fetched row

Brendan Over a year ago

No, the foreach is not useless. He is looping through all cells for the row. If you don't know the number of columns in the table, then you must loop through them all.

Collectives™ on Stack Overflow

PHP: apply CSS to every second row [duplicate]

2 Answers 2

1 Comment

2 Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

2 Comments

Linked

Related