$bg1 = "#dddddd";
$bg2 = "#ffffff";
While ...
$bg3 = $bg2;
$bg2 = $bg1;
$bg1 = $bg3;
echo "<tr bgcolor='$bg1'> ....

Makes sense?

<>< Ryan

-----Original Message-----
Sent: Sunday, January 25, 2004 6:43 PM
Subject: [PHP-DB] Results with ledger stripes?

Hello all,

I'm in the midst of creating an internet speed test system thingamabob
for my website.  It's basically finished...but ugly as sin.  What I'd
like to do is have the results (an average of each domain tested) listed
in a nice pretty table with alternating background colors, kinda like a
ledger.  How on earth do I do this?

Here's what I've got thus far:

echo "Average speeds of each domain tested:<br>"; $mongo = @mysql_query
substring_index(name,'.',-2),ROUND(AVG(speed),1) FROM `readings` GROUP
substring_index(name,'.',-2) ORDER BY substring_index(name,'.',-2)
ASC"); echo "<table><tr><td>Domain</td><td>Average Speed</td></tr>\n";
while ($mongorow = mysql_fetch_array($mongo, MYSQL_NUM)) { echo
echo "</table>";

And I'd like it to spit out something along these lines:
<tr bgcolor=#dddddd><td>domain1.com</td><td>666.6 kbps</td></tr> <tr
bgcolor=#ffffff><td>domain2.com</td><td>3000.0 kbps</td></tr> repeat
until done </table>

The gizmo is up and running at
http://www.dibcomputers.com/bandwidthmeter/index.php if you care to have
a gander.
Thanks a bunch,

PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Reply via email to