problem with color scheming

Muses

I am using an external style sheet.. here is the area that pertains to what I need to change based on selection.

.slist { font-weight: normal; color: #7B99FE;}
.alist { font-weight: normal; color: #a90003;}
.mlist { font-weight: normal; color: #3366CC;}
.hlist { font-weight: normal; color: #006600;}
.tlist { font-weight: normal; color: #009999;}

now based on the realm_id the colors should change but I am not entirely sure how to implement it in my code.

$cols = 2; // how many cols you want
echo '<table align=center width=100% border=0 cellspacing=3 cellpadding=3>';
$cols = 2; // how many cols you want
   $row['zone_id']= $_GET['zone_id'];
$result = mysql_query("SELECT zone.* FROM zone  WHERE 1 AND realm_id='$id' and category_id='5' ORDER BY zone ASC");

if (mysql_num_rows($result)) 
for($i=1;$row = mysql_fetch_array($result);$i++)
{
    if($i==1)
    {
        echo "<TR>";
    }
// this is the area that needs the color schema. 
    echo"<td width=50% valign=top><p>".$row['zone']."";
	// after this point all colors will remain standard. 
	     $sub_result = mysql_query("SELECT stable.*, stable_path.*  FROM stable, stable_path WHERE stable.zone_id=$row[zone_id] AND stable_path.stable_id=stable.stable_id ORDER BY stable ASC");
$count=mysql_num_rows($sub_result);      

     while( $sub_row = mysql_fetch_array($sub_result) ) 

 {
      echo("<li>".$sub_row['stable']." ".$sub_row['stable_way']." ".$sub_row['stable_to']."</li>");
}
echo"</p></td>";
if($i==$cols)
{
    echo "</TR>";
    $i=0;
}
}
if($i!=1)
{
    echo "</TR>";
}
echo "</table>";

Dvector

Add the CLASS attribute to your tag.

will change the attributes of the to the formatting you have in your CSS.

If you want to change it based on your realm_id, you can use an array of realm_id's where each realm_id is mapped to a style sheet class:

$realm_array = array("realm_id1" => "slist", "realm_id2" => "alist" . . . );

Then just use

Hope this helps.

Muses

where exactly do I put the

$realm_array = array("realm_id1" => "slist", "realm_id2" => "alist" . . . );

I put it after my query and before it, the color scheme still is not changing. Yes I also included the proper tag in the .

Dvector

Place the array after the query.

How many realm_id's do you have?

This is supposing that you have a finite set of realm_id's {1, . . . , 5}. If you have more then 5 (like a lot more), or a changing number of realm_id's, you will have to do it differently.

Muses

There are only 4 realm_id's I am working with on this.

BTW I have placed that bit of code after my query and it hasnt changed any colorings.

Dvector

Ok, I tried this myself, and it works, so there's something in your code you are missing.

1 - Make sure you are linking to your stylesheet, be sure this is in the <HEAD> of your document:
<LINK REL="stylesheet" TYPE="text/css" HREF="PATH_TO_CSS">

2 - Make sure the stylesheet is readable to the world:
chmod 644 stylesheet.css

3 - Your array will look something like this:

$realm_array = array("slist","alist","mlist","hlist","tlist");

4 - Your tag will look something like this:

Heres is an example of some code that prints out 5 "Hello's" using the stylesheet to change each color.

echo "<HEAD>";
echo "<LINK REL=\"stylesheet\" TYPE=\"text/css\" HREF=\"http://orst.edu/~cushmana/test.css\">";
echo "</HEAD>";

$realm_array = array("slist","alist","mlist","hlist","tlist");
echo "<P CLASS=\"$realm_array[0]\">Hello</P>";
echo "<P CLASS=\"$realm_array[1]\">Hello</P>";
echo "<P CLASS=\"$realm_array[2]\">Hello</P>";
echo "<P CLASS=\"$realm_array[3]\">Hello</P>";
echo "<P CLASS=\"$realm_array[4]\">Hello</P>";

If this doesnt work, show me more of your code, and what you are trying to do on it. This does work, it just needs to be implemented right.

Muses

my stylesheet is linked to every page through the inc/header.php. I just didnt include all that in my explanations.

stable.php (leads to the stable_list.php page)

    echo"<p align=justify>";
$row['realm_id']= $_GET['realm_id'];
$result = mysql_query("SELECT DISTINCT realm.* FROM  realm  WHERE 1 LIMIT 0,3");
echo mysql_error(); 
if (mysql_num_rows($result)) 
while($row = mysql_fetch_array($result)) {
    echo"<a href='stable_list.php?id=".$row['realm_id']."'>" . $row['realm'] . "</a><br/>";
}
    echo"</p>";

From here the links go to the individual details for each realm. I want the basic content text color to change based on the realm selection.

stable_list.php

        echo"<p align=justify>";
$row['realm_id']= $_GET['realm_id'];
$result = mysql_query("SELECT DISTINCT realm.* FROM  realm  WHERE realm_id='$id'");
echo mysql_error(); 

if (mysql_num_rows($result)) 
while($row = mysql_fetch_array($result)) {
   echo"<p align=justify><b>" . $row['realm'] . "</b></p>";
}
    echo"<p align=justify><b>Housing</b></p>";

$cols = 2; // how many cols you want
echo '<table align=center width=100% border=0 cellspacing=3 cellpadding=3>';
$cols = 2; // how many cols you want
   $row['zone_id']= $_GET['zone_id'];
$result = mysql_query("SELECT zone.* FROM zone  WHERE 1 AND realm_id='$id' and category_id='5' ORDER BY zone ASC");
//added the array here
$realm_array = array("alist","mlist","hlist","tlist");
if (mysql_num_rows($result)) 
for($i=1;$row = mysql_fetch_array($result);$i++)
{
    if($i==1)
    {
        echo "<TR>";
    }
    echo"<td width=50% valign=top><p class=$realm_array[$id]>".$row['zone']."";

     $sub_result = mysql_query("SELECT stable.*, stable_path.*  FROM stable, stable_path WHERE stable.zone_id=$row[zone_id] AND stable_path.stable_id=stable.stable_id ORDER BY stable ASC");
$count=mysql_num_rows($sub_result);      

     while( $sub_row = mysql_fetch_array($sub_result) ) 

 {
      echo("<li>".$sub_row['stable']." ".$sub_row['stable_way']." ".$sub_row['stable_to']."</li>");
}
echo"</p></td>";
if($i==$cols)
{
    echo "</TR>";
    $i=0;
}
}
if($i!=1)
{
    echo "</TR>";
}
echo "</table>";

Dvector

What values can $id hold?

Muses

Okay this is for a Guild Resource site for a MMORPG.

realm_id=1 (Albion) (alist)
realm_id=2 (Hibernia) (hlist)
realm_id=3 (Midgard) (mlist)
realm_id=4 (ToA) (tlist)