|
|
|
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 | | | Required form fields that pull from MySQL database Categories : PHP, HTML and PHP, Databases, MySQL | | | mySQL/PHP/search with multientry
form and table output with colored rows Categories : PHP, Beginner Guides, MySQL, HTML and PHP, Databases | | | Creating thumbnails from MySQL Blobs online Categories : PHP, MySQL, Graphics, HTML and PHP, Databases | | | Storing / Retrieving pictures from database This can be used for banner / ads exchange. very useful for people developing big portal with ads in the site........ Categories : PHP, MySQL, Databases, HTML and PHP | | | Function to do live population of HTML's <Select> tag from a Table Categories : PHP, MySQL, HTML and 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 | | | html split bar used to split in multiple pages a database result Categories : HTML and PHP, Databases, MySQL, PHP | | | Record Set Paging with PHP (RSP) Categories : PHP, MySQL, Navigation, Databases, HTML and PHP | | | Database resultset navigation Categories : PHP, HTML and PHP, Databases, MySQL, Navigation | | | This program will take data from a user via a web based form, validate it, show it
to the user for re-validation, and finally insert it into the database. Plenty of
sanity checking on the fields in the form.
Categories : MySQL, HTML and PHP, PHP, Complete Programs, Databases | | | Automatically printing the contents of an sql table in MySQL. Categories : MySQL, PHP, HTML and PHP, Databases | | | 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 | | | bookmarker - PHP, PHPLIB, MySQL WWW based bookmark manager Categories : MySQL, PHP, MySQL, Complete Programs, Databases | |
| | | | Tom Smith wrote :875
Just wot I was looking for :) Thanks very much to whoever wrote this.
(creating an insurance database)
| |
|
|