need to assign css class to <td> tag

[webguync]

Hello,

 

I am extracting data into an HTML table and I would like to make one of the table rows alternate colors by assigning a variety of CSS classes, but I am not sure how to do that within the PHP code I am using below:

 

any suggestions?

 

 

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

$fields_num = mysql_num_fields($result);

echo "<h1>JBossworld 2008 Agenda: {$table}</h1>";
echo "<table border='1'><tr id='headers'>";
// printing table headers
for($i=0; $i<$fields_num; $i++)
{
    $field = mysql_fetch_field($result);
    echo "<td>{$field->name}</td>";
}
echo "</tr>\n";
// printing table rows
while($row = mysql_fetch_row($result))
{
    echo "<tr>";

    // $row is array... foreach( .. ) puts every element
    // of $row to $cell variable
    foreach($row as $cell)
        echo "<td>$cell</td>";

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

[inet411]

Not sure if this is the 'correct' way but I would do something like:

 

 

inside of your loop put this:

 

 

$tdcolor = $tdcolor +1;
if ($tdcolor % 2 == 0 ){
  echo "<td class='even'>";
} else {
  echo "<td class='odd'>";
}

 

The if tdcolor %2 is an odd or even script, so if it is even it will show one color - odd the other.

 

[drummer101]

edit: misread inet411 is correct

 

$tdcolor is going to be mysql_num_rows($query)

[revraz]

It's a good way along with

 

if ($color == $color1){

$color = $color2;

}ELSE{

$color = $color1;

}

 

Not sure if this is the 'correct' way but I would do something like:

 

[webguync]

thanks,

 

what if I want to assign more than two different CSS classes to the <td>'s though? Can that be done?

[webguync]

also, where within the current code block would I need to place

$tdcolor = $tdcolor +1;
if ($tdcolor % 2 == 0 ){
  echo "<td class='even'>";
} else {
  echo "<td class='odd'>";
}

[drummer101]

also, where within the current code block would I need to place

where ever you're currently echoing your <td>

[Aureole]

<?php
$tdcolor = $tdcolor +1;
if ($tdcolor % 2 == 0 ){
  echo "<td class='even'>";
} else {
  echo "<td class='odd'>";
}
?>

 

...can be shortened to:

 

<?php
$tdcolor += 1;
echo($tdcolor % 2 == 0) ? '<td class="even">' : '<td class="odd">';
?>

[inet411]

<?php
$tdcolor = $tdcolor +1;
if ($tdcolor % 2 == 0 ){
  echo "<td class='even'>";
} else {
  echo "<td class='odd'>";
}
?>

 

...can be shortened to:

 

<?php
$tdcolor += 1;
echo($tdcolor % 2 == 0) ? '<td class="even">' : '<td class="odd">';
?>

 

Sorry to thread highjack but I tried your modified version of the code I wrote and it worked great.  I don't understand though the ? and the :  .  Could you explain that as if I was a two year old?  What I mean is the logic behind it.....

 

  I'm thinking the ? means if true do something : <--- (if false) something else and I'll also assume the +=1 then is the same as $whatever = $whatever + 1;  Am I correct in my assumptions?

[Aureole]

You would be correct in your assumptions.

[resago]

instead of adding, I would use *-1

then you could better assign the classes, because the names would be either 1 or -1.