t_machine Posted September 5, 2006 Share Posted September 5, 2006 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.blue2.red3.greenThen I would like the next three result to repeat the process4.blue5.red6.greenAny help would be greatly appreciated :) Quote Link to comment Share on other sites More sharing options...
AndyB Posted September 5, 2006 Share Posted September 5, 2006 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 somethingwhile ($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] Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.