changing color in DB?

[siwy]

I hope someone can help.
I have 2 check boxes in my form one for accept and one for decline. what i need is to show username in blue if accepted or in red when declined on another page.
Is it possible to change the color of a text stored in DB? what would be the best way to that? any ideas?

[rebelo]

I would create a field in the table for "accepted" or some such value that can be set to either 1 or 0. Then when you are printing the name from the db, grab that value as well...like so:

$result = mysql_query("SELECT * FROM users WHERE userid='$userid'");
$userinfo = mysql_fetch_array($result);
if($userinfo['accepted']){
echo "<font color=\"#0000FF\">";
}else{
echo "<font color=\"#FF0000\">";
}
echo $userinfo['name']."</font>";

[siwy]

thanks for your help rebelo i tryed your code but it gives me a parse error, don't know why.

[itworks]

in your echo statement where you output the member username, put this before <font color=\"#FF0000\"> an this after </font>.

#FF0000 - is the color (red in this case) change it to the one you want.

hope this helps.