MYSQL计算不同的单元格值

Question

I tried to count using following- include 'db_login';

    $sql = "(SELECT  * , COUNT(*)  FROM  `table1` 
    WHERE  `ADVERTISERCATEGORY` LIKE  '%something%'
    GROUP BY `MANUFACTURER` ORDER BY COUNT DESC )";
    $row = mysql_fetch_array($sql);
    $total = $row[0];
    echo "Total rows: " . $total;

but i got following error message-

Warning: mysql_fetch_array() expects parameter 1 to be resource, 
string given in /home/content/43/10130843/html/fashion_test.php on line 169

i am learning php/mysql therefore i need help. thanks

Answer 1

You haven't called mysql_query(), so you can't fetch the array yet...

$sql = "SELECT  * , COUNT(*)  FROM  `table1` 
WHERE  `ADVERTISERCATEGORY` LIKE  '%something%'
GROUP BY `MANUFACTURER` ORDER BY COUNT(*) DESC ";
$query = mysql_query($sql) or die(mysql_error()); // exit on error
$row = mysql_fetch_array($query);

Note: mysql_query() and the rest of the mysql_* library have been deprecated for some time, you should make the move to paramterized queries with mysqli_* or PDO while you're in the development phase.