colors...

boboli

Hi all....I hope you will understand my english...
this is my problem:
I have a table where in a particular field (let's call it "PDMA_field") you have to enter a letter that can be P, D, M, A depending on a particular situation
than I have a simple php page (let's call it viewdb.php) where I can see the entered data in nice formatted table
Is it possible to assign a different color to the entire row depending on this letter (P D M A) field ???

For example... if the PDMA_field ="A" than all the data in the row should be RED or even better assigned to a particular CSS class....

Thanx
Roberto

greg252

I assume that you mean After the submit.
Yes, you can, and you answered the question yourself. Use an if conditional or a switch to change the color:

if ($PDMA_field=="P"){
$bgcolor="red";
}
etc...

echo"
<tr bgcolor=$bgcolor><td>$PDMA_field</td></tr>";

boboli

Originally posted by greg252
I assume that you mean After the submit.
Yes, you can, and you answered the question yourself. Use an if conditional or a switch to change the color:

if ($PDMA_field=="P"){
$bgcolor="red";
}
etc...

echo"
<tr bgcolor=$bgcolor><td>$PDMA_field</td></tr>";

I tried but I think I have to add "else" somewhere as I need 3 or 4 different colors

this is the code I'm using in a different table...

<HTML>
<?php
$db = mysql_connect("fr**.be", "", "pwd");
mysql_select_db("mbo",$db);
$result = mysql_query("SELECT FROM personnel",$db);
echo "<TABLE>";
echo"<TR><TD><B>Full Name</B><TD><B>Nick Name</B><TD><B>Salary</B></TR>";
while($myrow = mysql_fetch_array($result))
{
echo "<TR><TD>";
echo $myrow["firstname"];
echo " ";
echo $myrow["lastname"];
echo "<TD>";
echo $myrow["nick"];
echo "<TD>";
echo $myrow["salary"];
}
echo "</TABLE>";
?>
</HTML>

in this code I need that the SALARY row will become RED if under a certain salary and green if over a certain salary staying black in between.... and becoming say blu when over another amount....
😃
still possible ???

boboli

????????it's not working.... ???????

mhoward

Try this...

<HTML> 
<HEAD>
</HEAD>
<BODY>
<?php 
$db = mysql_connect("fr*****.be", "******", "pwd"); 
mysql_select_db("****mbo",$db); 
$result = mysql_query("SELECT * FROM personnel",$db); 
echo "<TABLE>\n"; 
echo"<TR><TD><B>Full Name</B></TD><TD><B>Nick Name</B></TD><TD><B>Salary</B></TD></TR>\n"; 
while($myrow = mysql_fetch_array($result)) 
{ 
$firstname = $myrow[firstname];
$lastname = $myrow[lastname];
$nickname = $myrow[nick];
$salary = $myrow[salary];

if($salary < 10000)
{
$bgcolor = "RED";
}

elseif($salary > 50000)
{
$bgcolor = "GREEN";
}

else
{
$bgcolor = "BLACK";
}


echo "<TR BGCOLOR=\"$bgcolor\"><TD>\n"; 
echo "$firstname\n"; 
echo " "; 
echo "$lastname\n"; 
echo "</TD>\n";
echo "<TD>\n"; 
echo "$nick\n"; 
echo "</TD>\n";
echo "<TD>\n"; 
echo "$salary\n"; 
echo "</TD>\n";
} 
echo "</TABLE>\n"; 
?> 
</BODY>
</HTML>

boboli

Originally posted by mhoward
Try this...

<HTML> 
<HEAD>
</HEAD>
<BODY>
<?php 
$db = mysql_connect("fr*****.be", "******", "pwd"); 
mysql_select_db("****mbo",$db); 
$result = mysql_query("SELECT * FROM personnel",$db); 
echo "<TABLE>\n"; 
echo"<TR><TD><B>Full Name</B></TD><TD><B>Nick Name</B></TD><TD><B>Salary</B></TD></TR>\n"; 
while($myrow = mysql_fetch_array($result)) 
{ 
$firstname = $myrow[firstname];
$lastname = $myrow[lastname];
$nickname = $myrow[nick];
$salary = $myrow[salary];

if($salary < 10000)
{
$bgcolor = "RED";
}

elseif($salary > 50000)
{
$bgcolor = "GREEN";
}

else
{
$bgcolor = "BLACK";
}


echo "<TR BGCOLOR=\"$bgcolor\"><TD>\n"; 
echo "$firstname\n"; 
echo " "; 
echo "$lastname\n"; 
echo "</TD>\n";
echo "<TD>\n"; 
echo "$nick\n"; 
echo "</TD>\n";
echo "<TD>\n"; 
echo "$salary\n"; 
echo "</TD>\n";
} 
echo "</TABLE>\n"; 
?> 
</BODY>
</HTML>

[/B]

sorry I think I have not been enough clear...IT WORKS but this change background colors of the ROW...I actually need to change the color of the written data on the white rows.... :eek:
this is the page
http://web.frontera.be/fantalimbo/prova/viewdb2.php

I need to se John LEVER in green and Tonino Carino in red on white page.....

thank you very very very much....
Roberto

boboli

any idea ????

thanx
Roberto

eriksmoen

 <HTML> 
<HEAD>
</HEAD>
<BODY>
<?php 
$db = mysql_connect("fr*****.be", "******", "pwd"); 
mysql_select_db("****mbo",$db); 
$result = mysql_query("SELECT * FROM personnel",$db); 
echo "<TABLE>\n"; 
echo"<TR><TD><B>Full Name</B></TD><TD><B>Nick Name</B></TD><TD><B>Salary</B></TD></TR>\n"; 
while($myrow = mysql_fetch_array($result)) 
{ 
$firstname = $myrow[firstname];
$lastname = $myrow[lastname];
$nickname = $myrow[nick];
$salary = $myrow[salary];

if($salary < 10000)
{
$bgcolor = "RED";
}

elseif($salary > 50000)
{
$bgcolor = "GREEN";
}

else
{
$bgcolor = "BLACK";
}


echo "<TR><TD>\n"; 
echo "$firstname\n"; 
echo " "; 
echo "$lastname\n"; 
echo "</TD>\n";
echo "<TD>\n"; 
echo "$nick\n"; 
echo "</TD>\n";
echo "<TD>\n"; 
echo "<font color=$bgcolor>$salary</font>\n"; 
echo "</TD>\n";
} 
echo "</TABLE>\n"; 
?> 
</BODY>
</HTML>

this changes just the salary color.

boboli

I forgot to change the switch from new PHP to old HTML...:eek:

NOW IT ROCKS !!!!!!

thanx all great help !!!!!!!!!!!!

Roberto

boboli

Originally posted by eriksmoen

 <HTML> 
<HEAD>
</HEAD>
<BODY>
<?php 
$db = mysql_connect("fr*****.be", "******", "pwd"); 
mysql_select_db("****mbo",$db); 
$result = mysql_query("SELECT * FROM personnel",$db); 
echo "<TABLE>\n"; 
echo"<TR><TD><B>Full Name</B></TD><TD><B>Nick Name</B></TD><TD><B>Salary</B></TD></TR>\n"; 
while($myrow = mysql_fetch_array($result)) 
{ 
$firstname = $myrow[firstname];
$lastname = $myrow[lastname];
$nickname = $myrow[nick];
$salary = $myrow[salary];

if($salary < 10000)
{
$bgcolor = "RED";
}

elseif($salary > 50000)
{
$bgcolor = "GREEN";
}

else
{
$bgcolor = "BLACK";
}


echo "<TR><TD>\n"; 
echo "$firstname\n"; 
echo " "; 
echo "$lastname\n"; 
echo "</TD>\n";
echo "<TD>\n"; 
echo "$nick\n"; 
echo "</TD>\n";
echo "<TD>\n"; 
echo "<font color=$bgcolor>$salary</font>\n"; 
echo "</TD>\n";
} 
echo "</TABLE>\n"; 
?> 
</BODY>
</HTML>

this changes just the salary color. [/B]

Is it possible to manage it with letters instead of numbers ???
I tried to change the" > 10000"
with " = P"
but then it takes a P for all the other rows....

I need to assign a font color to a letter insteado of a number....

http://web.frontera.be/fantalimbo/prova/viewdb3.php

this is the page but the first row should be P instead of 1, than D instead of 2, C instead of 3 and A instead of 4.....

how can I manage it ????
ciao
Roberto

boboli

Originally posted by boboli

Is it possible to manage it with letters instead of numbers ???
I tried to change the" > 10000"
with " = P"
but then it takes a P for all the other rows....

I need to assign a font color to a letter insteado of a number....

http://web.frontera.be/fantalimbo/prova/viewdb3.php

this is the page but the first row should be P instead of 1, than D instead of 2, C instead of 3 and A instead of 4.....

how can I manage it ????
ciao
Roberto

sorry I resolved in this way:

if($ruolo < C)
{
$color = "RED";
}

elseif($ruolo < D)
{
$color = "GREEN";
}

elseif($ruolo < P)
{
$color = "BLUE";
}

else
{
$color = "BLACK";
}

NOW IT'S WORKING FINE !!!!!