 |
Submit Your Code | |
 |
SEO Monitor | |
 |
UpTime Monitor | |
 |
PHP Code Contest | |
 |
My Favorite Examples | |
|
My Favorite Articles | |
 |
Update Your Profile | |
|
|
| More Weber Sites | ||
| PHP Code Search | ||
| Web Development Forums | ||
| Learn MySQL Playing Trivia | ||
| PHPBB2 Templates | ||
| Web Development Index | ||
| Web Development Resources | ||
| Web Development Content | ||
| Recommended Links | ||
| PHPClasses | ||
| PHP Editor | ||
| PHP Jobs | ||
| Vision.To Design | ||
| Ajax Tutorials | ||
| PHP Programming Help | ||
| PHP/MySQL Programming | ||
| Webmaster Resources | ||
| Webmaster Forum | ||
| XML meta language | ||
| website builder | ||
| Recommended | ||
| Mobile Dev World | ||
|
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| Code | |||||
The following shows a table drawn from a databse (MySql in this case) using php to give red fonts for negative number and blue for positive numbers. The rows are also in alternate colors. You need t ofill in your own data and parameters for the database, of course. <table border=0 bgcolor=white width="502" cellpadding="0" cellspacing="0"> <tr><td> <table border="0" cellpadding="2" cellspacing="1" width="100%"> <tr bgcolor="336699"> <td align=middle id="header">a</td> <td align=middle id="header">b</td> <td align=middle id="header">c</td> <td align=middle id="header">d</td> <td align=middle id="header">e</td> </tr> <?php mysql_connect(localhost,user,password); $database="your_database"; @mysql_select_db("$database") or die( "Unable to select database"); $table="your_table"; $query="select * from $table where $table.data1=something AND $table.data2 >0 order by this_order"; $result=mysql_query($query); mysql_close(); /*Display Results*/ $num=mysql_num_rows($result); $i=0; while ($i < $num) { $a=mysql_result($result,$i,"a"); $b=mysql_result($result,$i,"b"); $c=mysql_result($result,$i,"c"); $d=mysql_result($result,$i,"d"); $e=mysql_result($result,$i,"e"); //Alternate row colors in our table print ($i % 2) ? "<tr bgcolor=\"CCCCCC\">" : "<tr bgcolor=\"BEEFFF\">"; print "<td align=right>$a</td>"; print "<td align=right>$b</td>"; print "<td align=right>$c</td>"; print "<td align=right>$d</td>"; print "<td align=right><span style=\"color:"; if ($d > 0){ print "blue"; } else { print "red"; } print ";\">$e</span></td>"; ++$i; } ?> </table> | |||||
| Related Code Examples | |||||
