Jump to content


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


How to repeat in mysql result

Recommended Posts

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

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


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


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

$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>";
echo "</table>";// end something

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.