Jump to content


Photo

How to repeat in mysql result


  • Please log in to reply
1 reply to this topic

#1 t_machine

t_machine
  • Members
  • PipPipPip
  • Advanced Member
  • 104 posts

Posted 05 September 2006 - 01:57 AM

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 :)

#2 AndyB

AndyB
  • Staff Alumni
  • Advanced Member
  • 5,465 posts
  • LocationToronto

Posted 05 September 2006 - 02:26 AM

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

<?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
?>

Legend has it that reading the manual never killed anyone.
My site




0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users