in PHP (I wouldn't try to do this in SQL) use this psuedo code:
$lcvA = 1;
while (you can still fetch rows){
$color = ($lcvA%2)=0 ? "RED" : "GREEN";
echo "<TR bgcolor=\"$color\">";
.
.
.
$lcvA++;
}
HTH,
Cal
http://www.calevans.com
-----Original Message-----
From: Mike Roberts [mailto:[EMAIL PROTECTED]]
Sent: Thursday, March 29, 2001 12:12 PM
To: [EMAIL PROTECTED]
Subject: How?
I'm using PHP and Mysql.
I was wondering how you can spit out information out of a
database onto a table, but have every second row of the
table a different backround color.
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
