|
|
|
Using a query from from a MySql Database alternate the color of the table row each time through the loop.
| <?php
$qry = "Select * from table";
$result = myql_query($qry);
$rs = 0; // set count of array to be 0 for first run
for($i = 0; $i < count($rs); ) {
while ($rs = mysql_fetch_array($result)) {
//divde the count by two and see if there is a remainder(odd number) and assign a color.
$bgcolor = ($i % 2) ? 'blue' : 'black';
//print results....
print "<tr>
<td bgolor=\"$bgcolor\">First Cell</td>
<td bgolor=\"$bgcolor\">Second Cell</td>
<td bgolor=\"$bgcolor\">Third Cell</td>
</tr>"; //etc
$i++;
}
}
?> | |
I posted this on a PHP board and it was suggested i post here. Hope this helps
someone. |
|
| Message of the Day - Random Message (Needs MySQL!)
Categories : Databases, HTML and PHP, PHP, MySQL | | | A very simple way to build and do a hierarchical html categories browser without javascript , just using html php and mySql
Categories : HTML and PHP, Databases, Algorithms, PHP, MySQL | | | Automatically printing the contents of an sql table in MySQL.
Categories : MySQL, PHP, HTML and PHP, Databases | | | Pull Down Surfing - Surf on Change
Categories : Java Script, MySQL, HTML and PHP, PHP, Databases | | | Dynamically generated pop-ups (Select items)
Categories : PHP, HTML and PHP, MySQL, Databases | | | Creating thumbnails from MySQL Blobs online
Categories : PHP, MySQL, Graphics, HTML and PHP, Databases | | | Functions for loading images into a MySQL database and displaying them.
Categories : Graphics, HTML and PHP, MySQL, PHP, Databases | | | Editing the virtusertable and sendmail.cw via PHP3.0 and Mysql
Categories : MySQL, HTML and PHP, PHP, Databases | | | This function will populate the options in a drop down HTML select list
in a form from a database query.
Categories : MySQL, General SQL, PHP, HTML and PHP, Databases | | | How can i Preload a 'SELECT MULTIPLE'?
Categories : HTML and PHP, PHP, MySQL, Databases | | | Record Set Paging with PHP (RSP)
Categories : PHP, MySQL, Navigation, Databases, HTML and PHP | | | dynamic table columns
Categories : PHP, HTML and PHP, Arrays, Databases, MySQL | | | mySQL/PHP/search with multientry
form and table output with colored rows
Categories : PHP, Beginner Guides, MySQL, HTML and PHP, Databases | | | Paginating the mySQL data
Categories : PHP, Algorithms, Databases, MySQL, HTML and PHP | | | PHP and MySQL scripting for Muyltiple CheckBoxes
Categories : HTML and PHP, MySQL, Databases, PHP | |
| | | | Tom Smith wrote :875
Just wot I was looking for :) Thanks very much to whoever wrote this.
(creating an insurance database)
| |
|
|
|
