RE: [PHP-DB] Displaying SQL Results

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@gmail.com> To: php-db@lists.php.net Subject: [PHP-DB] 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