Hey everyone!
Thanks for all the hints--here's what my boss and I eventually came out with:
/* ######################
## And for every row of data we pull, we create a table row...
###################### */
$company = 0;
$previous = "";
for ($i = 0; $i < mssql_num_rows( $stmt ); ++$i)
{
$line = mssql_fetch_row($stmt);
$company +=
(strcmp($previous,$line[0]) ? 1 : 0);
$color = (($company%2) ? "FFFFFF" :
"FFFF00");
$cname = (strcmp($previous,$line[0])
? $line[0] : " ");
print ("<TR
BGCOLOR=#$color>\n\t<TD>$line[2]</TD>\n\t<TD>$cname</TD>\n\t<TD>$line[3]</TD>\n</TR>\n");
$previous = $line[0];
}
print ("</TABLE>");
This not only takes care of the table row colors, but also removes
duplicate company names so it looks MUCH neater this way :))))
Thanks again!
Glenn
(who's still trying to get it all down lol.. between trying to learn SQL,
MySQL,PHP, PostgreSQL, and VBScript lately, I'm surprised I haven't had my
head explode yet!)
---
Glenn E. Sieb, System Administrator
Lumeta Corp. mailto:[EMAIL PROTECTED]
+1 732 357-3514 (V)
+1 732 564-0731 (Fax)
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
