Re: Results with ledger stripes?

This is the best contact description that I found so far on the net ! To contact Dan, the owner and lead technician, please email him at dan@dibcomputers.com. In case of dire emergency, crashed network, or other pressing need you may also contact him 24 hours a day via cell phone at xxx-xxx-xx. Please be nice, though, as he does like to sleep once in a while! :) "http://www.dibcomputers.com/contact.html" ----- Original Message ----- From: <dan@dibcomputers.com> To: <php-db@lists.php.net> Sent: Monday, January 26, 2004 03:42 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: > > <?php > echo "Average speeds of each domain tested:<br>"; > $mongo = @mysql_query ("SELECT > substring_index(name,'.',-2),ROUND(AVG(speed),1) FROM > readings GROUP BY > 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 > > "<tr><td>$mongorow[0]</td><td>$mongorow[1]</td></tr>\n";} > echo "</table>"; > ?> > > And I'd like it to spit out something along these lines: > <table> > <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, > Dan > > ---------------------------------------------------------------------------- ---- > -- > PHP Database Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php