|
|
Posted by Jochem Maas on 03/30/05 19:17
Georg wrote:
> Hi!
>
> I wish to format the output of a database select.
> The result is presented in a table, in which i'd like to present everey
> secound row with a different background color.
> My idea was to test if the remaining number of rows where a prime number or
modulo 2 .... is the current row 'number' divisible by 2 with no remainder?
(i.e. is it an odd row or an even row)
hint code:
$i = 1;
// assume $rows is your DB resultset
foreach($rows as $row) {
$bgcolor = ($i % 2) ? '#fff': '#f00';
$i++;
$yourColumns = '';
foreach ($row as $field) {
$yourColumns =. "<td>$field</td>";
}
echo '<tr style="'.$bgcolor.'">',$yourColumns,'<tr>';
}
I really think that prime numbers are not what your looking for....
but maybe you have very specific formatting requirements?!!??
> not, and by that determent if the background color should be white or som
> ivory-like color to improve the readability in the result table...
>
> Hope to hear from anyone with experience in similar matters...
btw there are quite a few javascript libs that do auto coloring of HTML tables
in the way you describe - they are pretty much drag'n'drop scripts - I'll
leave finding them up to you ;-)
>
> TIA! Georg Herland, Norway
>
Navigation:
[Reply to this message]
|