How to Display Query Results

[Anon]

I can run the following from the command line and get the output I want:

SELECT one, COUNT(one) FROM today_table GROUP BY ONE

But how do I get those results into a webpage?

Many many thanks in advance!

Ted

[Anon]

$sql = "SELECT one, COUNT(one) FROM today_table GROUP BY ONE";

//$dbconn ..is the database connection
$result = mysql_query($sql, $dbconn);

while (list($one, $count) = mysql_fetch_row($result))
{
echo "one is: $one<br>count is: $count<br>";

}