[RESOLVED] I need help with Alt row color

impactdesignpro

I am having trouble getting my rows to alternate color. Here is my core script.
Can someone tell me what to do?

<?php
include("includes/config.inc.php");

// Connect to server and select database.
mysql_connect("$host", "$username", "$password")or die("cannot connect"); 
mysql_select_db("$db_name")or die("cannot select DB");

$sql="SELECT * FROM $tbl_name ORDER BY year DESC, month DESC, day DESC";
$result=mysql_query($sql);
?>
<style type="text/css">
<!--
.style4 {font-family: Verdana, Arial, Helvetica, sans-serif; font-weight: bold; font-size: 12px; }
.style6 {font-family: Verdana, Arial, Helvetica, sans-serif; font-size: 12px; }
.smmain {font-family: Verdana, Arial, Helvetica, sans-serif;
	font-weight: normal;
	font-size: 11px;
}
.style8 {font-family: Verdana, Arial, Helvetica, sans-serif; font-weight: bold; font-size: 12px; color: #FFFFFF; }
-->
</style>
</head>

<body>
<table width="100%" border="1" cellspacing="0" cellpadding="3">
  <tr>
    <td colspan="5"><span class="style4">Online Database </span></td>
  </tr>
  <tr>
    <td width="12%" align="center" bgcolor="#006600"><span class="style8">Date</span></td>
    <td width="35%" align="center" bgcolor="#006600"><span class="style8">Title</span></td>
    <td width="24%" align="center" bgcolor="#006600"><span class="style8">Speaker</span></td>
    <td width="15%" align="center" bgcolor="#006600"><span class="style8">Update</span></td>
    <td width="14%" align="center" bgcolor="#006600"><span class="style8">Delete</span></td>
  </tr>
  <?php
while($rows=mysql_fetch_array($result))
{
?>
  <tr>
    <td><div align="center"><span class="style6"><? echo $rows['month']; ?></span>/<span class="style6"><? echo $rows['day']; ?></span>/<span class="style6"><? echo $rows['year']; ?></span></div></td>
    <td><span class="style6"><? echo $rows['title']; ?></span></td>
    <td><span class="style6"><? echo $rows['speaker']; ?></span></td>
    <td align="center"><a href="update.php?id=<? echo $rows['id']; ?>" class="style6">Update</a></td>
    <td align="center"><a href="delete.php?id=<? echo $rows['id']; ?>" class="style6">Delete</a></td>
  </tr>
  <?php
}
?>
</table>
<?php
mysql_close();
?>

impactdesignpro

Never mind... I figured it out

ddconcepts

A REALLY easy way to get alternatively shaded lines when extracting and displaying info from a database...

$query = "SELECT * FROM users ORDER BY lastname";
$result = mysql_query($query) or die ("Could not find User Access");
while ($row = mysql_fetch_array($result)) {
extract($row);

		if ($alternate =="1") {		//alternate coloured lines
		$shade = "#F3F3F3";	$alternate = "2";
		}else {	$shade ="#FFFFFF"; $alternate = "1";}

		echo "<tr bgcolor=$shade><td>$firstname...(etc)

}

immediately after your data query include the above 3 lines of code for alternative colour. then just put bgcolor=$shade on row attribute that displays data on page table.

dewcansam

Actually, you can shorten this even further by just using 2 lines;

$rownum = 0;
while($row = mysql_fetch_object($qid)){
    $rowcolor = ($rownum % 2) ? "#FFFFCC" : "#FFFFFF"; $rownum++;
    echo "<tr bgcolor=$rowcolor>";
    .........
}

init a tmp var
check to see if it is even or not
increment tmp var