> -----Original Message-----
> From: Scott Saraniero [mailto:[EMAIL PROTECTED]]
> Sent: 18 February 2002 18:02
> To: [EMAIL PROTECTED]
>
> I've got a piece of code below that works great for me. Now I
> would like to
> modify the rows with alternating colors in the displayed results. Any
> suggestions on how to do this?
Easy one: see additional/changed lines below:
>
> <?php
>
> $Host = "";
> $User = "";
> $Password = "";
> $DBName = "";
> $TableName = "";
>
> $Link = mysql_connect($Host, $User, $Password);
>
> $Query = "SELECT * FROM $TableName";
>
> $Result = mysql_db_query($DBName, $Query, $Link);
>
>
>
> print ("<table border=1 width=\"65%\" cellpadding=3 align=center>");
> print ("<tr>");
> print ("<th class=\"textOnWhite\">Song</th>");
> print ("<th class=\"textOnWhite\">Artist</th>");
print "</tr>"; // ** missing in your original!! **
$alt_color = TRUE;
>
> while ($Row =mysql_fetch_array($Result)) {
> print ("<tr>");
$class = $alt_color ? 'textOnColor' : 'textOnWhite';
> print ("<td class=\"$class\">$Row[song]</td>");
> print ("<td class=\"$class\">$Row[artist1]
> $Row[artist]</td>");
>
>
$alt_color = !$alt_color;
>
> }
> print "</table>";
>
>
>
>
> mysql_close($Link);
>
> ?>
>
> Thanks,
> Scott
>
>
> --
> PHP General Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
