Rotating Font Colors

x3roXL

I was wondering how I would get the text pulled from my mysql database to change colors. Like.. the first one blue, second red, then blue, then red, etc..

rebelo

Just run a loop cycling the output colours. Something like this:

// Get the resulting rows
$query = "SELECT * FROM table";
$result = mysql_query($query);

// initialize the colour variable
$color = 1;

// Go into a loop grabbing rows one at a time
while ($line = mysql_fetch_assoc($result)) {
    if ($color == 1) {
        echo "<font color=red>$line[0]</font>";
        $color++;
    } elseif ($color == 2) {
        echo "<font color=blue>$line[0]</font>";
        $color++;
    } elseif ($color == 3) {
        echo "<font color=green>$line[0]</font>";
        $color =1;
    }
}

Could probably be prettier, but that's the idea.

Drakla

Yikes - font tags. You can also do it with css and table rows like in this example http://www.desilva.biz/php/alternate.html

If you need to use loads of colours or styles just throw them in an array then use the modulus operator and a counter to cycle through them

	// css styles defined elsewhere
$rowStyles = array('rowLight', 'rowDark', 'rowHot', 'rowCold');
	// well this will be 4
$numStyles = count($rowStyles);

$count = 0;

echo '<table>';
while ($row = mysql_fetch_assoc($result))
{
	echo '<tr><td class="';
	echo $rowStyles[$count % $numStyles];	// will cycle 0, 1, 2, 3
	echo '">', $row['somefing'], '</td></tr>';

$count++;
}
echo '</table>';

x3roXL

Thanks. I used rebelo's way.

rebelo

Originally posted by Drakla
Yikes - font tags. You can also do it with css and table rows like in this example http://www.desilva.biz/php/alternate.html

While I definitely don't refute that using <font> tags is very deprecated and css is far more advanced and nice to use, that argument doesn't really have any bearing on what he's trying to do nor is it the subject of this board. I assumed anyone would understand the example as rudimentary structure and could fill in the output with whatever they liked.

madwormer2

Maybe they should view the source of this forum. <font> tags GALORE!!!

Weedpacket

Originally posted by rebelo
I assumed anyone would understand the example as rudimentary structure and could fill in the output with whatever they liked.

'Xcept it seems they didn't. Cut-and-paste coding is common enough as it is without encouraging it, which is why I have a policy of not just giving a chunk of code as an answer.