How to decide the font color php according to the sql query

Asked By Kevin Molina 10 points N/A Posted on - 10/22/2012

Hi,

I am a student that learning web development.

I have a small online application.

In that the color of the same massage should he different from the SQL quarry the run.

I can’t figure out this myself.

Please help me with this.

Thank you.

• Status: Open
• Question Views: 826
• Answer Count: 1
• Vote Up 0 Vote Down

• Answer Accepted: No
• Question Category: Web

Answered By Sierra Adams 10 points N/A #152513

How to decide the font color php according to the sql query

Hi,

You can do it by getting the value from the database and assigning it as a color to the element. Check the following code as an example:

<?php

 

$result = mysql_query("SELECT * FROM Colors");

 

echo "<table border='3'>

 

<tr>

 

<th>Colors</th>

</tr>";

while($row = mysql_fetch_array($result))

 

  {

  echo "<tr>";

 echo "<td style=’color:”. $row['Color'].“’>" . $row['Color'] . "</td>";

 

  echo "</tr>";

  }

echo "</table>";

 

?>

 

I hope this will helps you.

 

Thank you

 

About Sierra Adams

Questions
1

Answers
101

Best Answers
39

• Vote Up 0 Vote Down

• Posted on - 10/24/2012
• Question Category: Web