Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
alternating table row color
- Thread starter yerfdog
- Start date
sleipnir214
Programmer
Something like this?
______________________________________________________________________
TANSTAAFL!
Code:
<?php
print '<html><head><style>
.gray { background-color: gray; };
.white { background-color: white; };
</style></head><body><table border=1>';
$dbh = mysql_connect ('localhost', 'fu', 'bar');
mysql_select_db('fubar', $dbh);
$rh = $mysql_query ("SELECT fu, bar from fubar", $dbh);
$counter = 0;
while ($result = mysql_fetch_array ($rh))
{
print '<TR class=';
print ($counter % 2 == 0)? "gray" : "white";
print '><td>$result['fu']</td><td>$result['bar']</td></tr>';
$counter++;
}
print '</table></body></html>';
?>TANSTAAFL!
- Thread starter
- #3
OK, sorry it took so long to get back to you, but I got swamped.
I tried experimenting with what was provided above, but I'm very new at php (teaching myself for 2 weeks) and I'm not sure how to incorporate what's above with what I have that is currently working below.
<?php
trim($searchterm);
if (!$searchtype || !$searchterm)
{
echo "<p align=center><b>You have not entered search details. Please go back and try again.</b></p>";
exit;
}
/* Connecting, selecting database */
@ $db = mysql_connect("db_host", "db_user", "db_pass"
or die("Could not connect"
mysql_select_db("db" or die("Could not select database"
/* Performing SQL query */
$query = "SELECT * FROM table WHERE ".$searchtype." LIKE '%".$searchterm."%' order by 'name' asc";
$result = mysql_query($query) or die("Query failed"
$num_results = mysql_num_rows($result);
print "<p><b>Your search produced ".$num_results." matches.</b></p>";
/* Printing results in HTML */
print "<table border=\"1\" cellspacing=\"0\" cellpadding=\"4\" width=\"500\" align=\"center\">\n";
print "<tr>\n";
print "<td bgcolor=#0099CC colspan=\"3\" width=\"50%\" align=\"center\"><p><b>Organization</b></p></td>\n";
print "<td bgcolor=#0099CC colspan=\"5\" align=\"center\"><p><b>Information</b></p></td>\n";
print "</tr>\n";
while ($row = mysql_fetch_assoc($result)) {
print "<tr>\n";
printf("<td colspan=\"3\"><p><b>%s</b><br> %s<br> %s</td><td align=\"right\" colspan=\"5\"><p>%s<br> %s, %s. %s<br> %s</td>\n", $row['Name'], $row['Gender'], $row['Affiliation'], $row['Address'], $row['City'], $row['State'], $row['Zip'], $row['Phone']);
print "\t</tr>\n";
}
print "</table>\n";
/* Free resultset */
mysql_free_result($result);
/* Closing connection */
mysql_close($db);
?>
yerfdog
I tried experimenting with what was provided above, but I'm very new at php (teaching myself for 2 weeks) and I'm not sure how to incorporate what's above with what I have that is currently working below.
<?php
trim($searchterm);
if (!$searchtype || !$searchterm)
{
echo "<p align=center><b>You have not entered search details. Please go back and try again.</b></p>";
exit;
}
/* Connecting, selecting database */
@ $db = mysql_connect("db_host", "db_user", "db_pass"
or die("Could not connect"
;mysql_select_db("db"
or die("Could not select database"/* Performing SQL query */
$query = "SELECT * FROM table WHERE ".$searchtype." LIKE '%".$searchterm."%' order by 'name' asc";
$result = mysql_query($query) or die("Query failed"
;$num_results = mysql_num_rows($result);
print "<p><b>Your search produced ".$num_results." matches.</b></p>";
/* Printing results in HTML */
print "<table border=\"1\" cellspacing=\"0\" cellpadding=\"4\" width=\"500\" align=\"center\">\n";
print "<tr>\n";
print "<td bgcolor=#0099CC colspan=\"3\" width=\"50%\" align=\"center\"><p><b>Organization</b></p></td>\n";
print "<td bgcolor=#0099CC colspan=\"5\" align=\"center\"><p><b>Information</b></p></td>\n";
print "</tr>\n";
while ($row = mysql_fetch_assoc($result)) {
print "<tr>\n";
printf("<td colspan=\"3\"><p><b>%s</b><br> %s<br> %s</td><td align=\"right\" colspan=\"5\"><p>%s<br> %s, %s. %s<br> %s</td>\n", $row['Name'], $row['Gender'], $row['Affiliation'], $row['Address'], $row['City'], $row['State'], $row['Zip'], $row['Phone']);
print "\t</tr>\n";
}
print "</table>\n";
/* Free resultset */
mysql_free_result($result);
/* Closing connection */
mysql_close($db);
?>
yerfdog
sleipnir214
Programmer
The core of the idea is to maintain a counter. As you output each row to check whether that counter is an even multiple of 2.
"$counter % 2" uses the modulus operator "%". Modulus returns the remainder of division. If "$counter % 2" is zero, the value in $counter is even.
Then use the result of the modulus to determine whether to set the table row's class to "gray" or "white".
The two classes are defined in the "<style>" section output at the top of the script. ______________________________________________________________________
TANSTAAFL!
"$counter % 2" uses the modulus operator "%". Modulus returns the remainder of division. If "$counter % 2" is zero, the value in $counter is even.
Then use the result of the modulus to determine whether to set the table row's class to "gray" or "white".
The two classes are defined in the "<style>" section output at the top of the script. ______________________________________________________________________
TANSTAAFL!
- Status