Glenn Sieb wrote:
>
> 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 :))))
YIKES! I thought there was a SQL keyword for returning a unique
rowset.
Cheers,
Rob.
--
.-----------------.
| Robert Cummings |
:-----------------`----------------------------.
| Webdeployer - Chief PHP and Java Programmer |
:----------------------------------------------:
| Mail : mailto:[EMAIL PROTECTED] |
| Phone : (613) 731-4046 x.109 |
:----------------------------------------------:
| Website : http://www.webmotion.com |
| Fax : (613) 260-9545 |
`----------------------------------------------'
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
