[RESOLVED] Categorizing by color

[Jon12345]

I have a list of values presented on a page, taken from a MySQL db. They list just great but it is a sea of white. What would be nice is to have each Category ID broken up by a different color. e.g. if Category ID="Internet", then its blue, if its "Business" then its green etc.

Any ideas how to do this? My code is below.

 <?
include('dbconnect.inc');

// Perform Query
$result = mysql_query("SELECT * FROM products ORDER BY CategoryID, Product, SubProduct");

while ($row = mysql_fetch_assoc($result)) {

echo "<tr>";
echo "<td>";
echo "<a href='edit.php?id=".$row['ProductID']."'>edit</a> | <a href='delete.php?id=".$row['ProductID']."'>delete</a>";
echo "</td>";
echo "<td>";
echo $row['ProductID'];
echo "</td>";

echo "<td>";
echo $row['CategoryID'];
echo "</td>";

echo "<td>";
echo $row['Product'];
echo "</td>";

echo "<td>";
echo $row['SubProduct'];
echo "</td>";

echo "<td>";
echo $row['CategoryID']." > ".$row['Product'].": ".$row['SubProduct'].": ".$row['SubProduct'];
echo "</td>";

echo "</tr>";

}
mysql_close();
?>

[TheDefender]

background-color is an attribute that can be set for the <TR> tag so create a style sheet and define your different color attributes using the applicable names.

So your css may look something like this:

tr.Internet{
background-color: #0000FF;
}
tr.Business{
background-color: #00FF00;
}

Then in your code, add a class attribute to the <TR> tag.

while ($row = mysql_fetch_assoc($result)) {

echo "<tr class=\"".$row['CategoryID']."\">";
echo "<td>";

This is going to screw you up if your Category IDs use more than one word, and you may need to do something else, like using a case/switch in your definitions. Without knowing for sure, let's start with this, and go from there.

[Jon12345]

Wow, thats clever! I am going to use that. Thanks you. 🙂

[TheDefender]

Let me know if this doesn't work for you, or if you want to further explore the other option I mentioned due to the use of using multiple words for a particular CategoryID...