Jump to content

Archived

This topic is now archived and is closed to further replies.

t_machine

How to repeat in mysql result

Recommended Posts

Hi, I would like to know how to repeat a process during a mysql result.

example:
I would like the first three results to have text colors:

1.blue
2.red
3.green

Then I would like the next three result to repeat the process

4.blue
5.red
6.green

Any help would be greatly appreciated :)

Share this post


Link to post
Share on other sites
This will give you the general idea. This example uses three colours but could be as many as you want by adding more to the array

[code]<?php
$colors = array("#0000cc", "#cc0000", "#00cc00"); // as colors many as you want

// database connection, etc. and other code


$query = "SELECT ... whatever"; // set up query
$result = mysql_query($query); // execute query

// display results ///
echo "<table>"; // start something
while ($row = mysql_fetch_array($result) {
    extract $row;
    $rowx = $row % count($colors);
    echo "<tr bgcolor='". $colors[$rowx]. "'>";
    echo "<td>". $row['somefield']. "</td>"; // dispay the results data
    echo "</tr>";
    $row++;
}
echo "</table>";// end something
?>[/code]

Share this post


Link to post
Share on other sites

×

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.