returning data in table format

knwebs

Hey devs, does anyone know how to return data to the screen in table format where one line is grey and the next line is white. So on and so forth??? I see it done on many pages and a sinch using ASP BUT can't get it to work with Php. If anyone has a snip of code please post it. I will do some searching and keep working on it and post my findings if someone else doesn't know.

csousley

I'm not exactly sure if this is what your looking for, but I think so.

	echo "<table cellpadding='0' width='600' cellspacing='5' class='body' bgcolor='#FFFFFF'>\n";
	$bgc = "FFFFFF";
	$bgcn = 1;
	for ($i2=0; $i2<$num2; $i2++) {
		$row2 = mysql_fetch_array($result2);
		$empfirstn = $row2['empfirstn'];
		$emplastn = $row2['emplastn'];
		$schnotes = $row2['schnotes'];
		$schjobid = $row2['schjobid'];
		$empseniornum = $row2['empseniornum'];
		$query_jn = "select * from jobs where jobid = $schjobid";
		$result_jn = mysql_query($query_jn);
		$row_jn = mysql_fetch_array($result_jn);
		$jobname = $row_jn['jobname'];
		echo "<tr><td bgcolor='#$bgc'>$empseniornum</td><td bgcolor='#$bgc'>$empfirstn</td><td bgcolor='#$bgc'>$emplastn</td><td bgcolor='#$bgc'>$jobname</td></tr>";
		if ($bgcn == 1) {
			$bgcn = 0;
			$bgc = "EEEEEE";
		}else{
			$bgcn = 1;
			$bgc = "FFFFFF";
		}
	}
	echo "</table>\n<p>";

Hope this helps

-Cy

Sxooter

I always do something like this:

for ($i=0;$i<$rows;$i++){
    if ($i%2==0) $bg="ffffff";
    else $bg="cccccc";
    print $data[$i];
}

That's a modulo operator, the % thing.  works a charm.  Plus, it lets you do things like %3 so that every 3rd line is a different color.

csousley

Hey that's slick, use Sxooter's code instead of mine. That a much cleaner way to get the same result.

-Cy

knwebs

you guys are amazing! Thanks