MYSQL-计算不同的单元格值

Question

我尝试使用以下命令进行计数- 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;

但我得到了以下错误信息-

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

我正在学习php/mysql，所以我需要帮助。谢谢

Answer 1

您还没有调用mysql_query()，所以您还不能获取数组...

$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);

注意： mysql_query() and the rest of the mysql_* library have been deprecated在一段时间内，您应该在开发阶段使用mysqli_*或PDO进行参数化查询。