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@xxxxxxxxxxxxxxxxx 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@xxxxxxxxxxxxxxxx> To: <php-db@xxxxxxxxxxxxx> Sent: Monday, January 26, 2004 03:42 Subject: 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 -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
