Thanks for the quick reply. Actually I figured it out by using aliasing:
$sql_records = "SELECT MAX(user) AS user_name, email, COUNT(user) AS
user_count FROM table_1 GROUP BY user DESC LIMIT 10;";
print $row["user_name"] . " - " . $row["user_count"];
This will display the top 10 users in descending order.
On 9/8/06, Bastien Koert <bastien_k@xxxxxxxxxxx> wrote:
try
while($row = $db->sql_fetchrow($result))
{
//[INSERT CODE HERE, I want to display the 'user' and 'count']
$user = $row[0];
$count = $row[1];
}
bastien
>From: JM <frawst1@xxxxxxxxx>
>To: php-db@xxxxxxxxxxxxx
>Subject: Displaying SQL Results
>Date: Fri, 8 Sep 2006 11:58:46 -0700
>
>Hi all,
>Can anyone tell me what the syntax would be to display or gather the
>results
>of this SQL?
>
>SELECT MAX(user), COUNT(*) FROM my_table GROUP BY user ASC;
>
>$sql_records = "SELECT MAX(user), email, COUNT(*) FROM my_table GROUP BY
>user ;";
>
>if($result = $db->sql_query($sql_records))
>{
>// fetch associative array
> while($row = $db->sql_fetchrow($result))
> {
>
> [INSERT CODE HERE, I want to display the 'user' and
'count']
>
> }
> $db->sql_freeresult($result);
>}
>
>
>
>Thanks for any help!
>
>J
