John Harbert John Harbert - 1 year ago 80
jQuery Question

Zebra Stripe PHP MYSQL Table

I would like to Zebra Stripe the results table. I can't find a solid solution. What would I need to do to this table to add a odd/even class to the results rows?

// HTML ... Aliases from Mysql
echo "<table class='sortable' id='tablesorter' cellspacing='1' cellpadding='0' border='0' width='920px' >
<th class='header'>Short Name of Fund</th>
<th class='header'>I/C</th>
<th class='header'>Fund Manager Company</th>
<th class='header'>Class</th>
<th class='header'>Special Class</th>
<th class='header' id='custom'>TTR year-to-date<br /> %</th>
<th class='header'>Mgmt Fee Effectively Charged</th>
<th class='header id='custom'>Total Expenses <br /> %</th>
<th class='header'>Fund Size</th>


//<tr> specifies table row. for each <td> (table data) will specify a new column. The $row specifies the mysql column name (in this case using an alias)
while($row = mysql_fetch_array($result))
echo "<tr>";
echo "<td><a href=\"page.php?id={$row['ID']}\">{$row['Short Name of Fund']}</a></td>";
echo "<td>" . $row['I/C'] . "</td>";
echo "<td>" . $row['Fund Manager Company'] . "</td>";
echo "<td>" . $row['Class'] . "</td>";
echo "<td>" . $row['Special Class'] . "</td>";
echo "<td>" . $row['TTR year-to-date %'] . "</td>";
echo "<td>" . $row['Mgmt Fee Effectively Charged'] . "</td>";
echo "<td>" . $row['Total Expenses %'] . "</td>";
echo "<td>" . $row['Fund Size'] . "</td>";

echo "</tr>";
echo "</tbody></table>";

Answer Source

This should work, the syntax may be incorrect as I have not tested it. But the logic is there.

$currentState = 'odd';
$html = '';
while($row = mysql_fetch_array($result)){
    $currentState = ($currentState == 'odd' ? 'even' : 'odd');
    $html .= '<tr class="'.$currentState.'">';
    $html .= '<td><a href="page.php?id=' . $row['ID'] . '">'. $row['Short Name of Fund'] .'</a></td>';
    $html .= '<td>' . $row['I/C'] . '</td>';
    $html .= '<td>' . $row['Fund Manager Company'] . '</td>';
    $html .= '<td>' . $row['Class'] . '</td>';
    $html .= '<td>' . $row['Special Class'] . '</td>';
    $html .= '<td>' . $row['TTR year-to-date %'] . '</td>';
    $html .= '<td>' . $row['Mgmt Fee Effectively Charged'] . '</td>';
    $html .= '<td>' . $row['Total Expenses %'] . '</td>';
    $html .= '<td>' . $row['Fund Size'] . '</td>';
    $html .= '</tr>';
echo $html;

EDIT: Updated code so it works.

Recommended from our users: Dynamic Network Monitoring from WhatsUp Gold from IPSwitch. Free Download