mysql - SQL 错误 : USE `most` ; SELECT `item_name` , SUM (`stock_invent` ) AS `Total Items` FROM inventory GROUP BY `item_name

Question

我试图通过 SQL 打印出项目的列表总数。它在 phpmyadmin 上运行良好，但在 Dreamweaver 中则不然。我不知道我的 SQL 有什么问题。有人可以帮助我吗？

mysql_select_db($database_dbcon, $dbcon);

$query_Recordset1 = "USE `most`; SELECT `item_name`, SUM(`stock_invent`) AS `Total Items` FROM inventories GROUP BY `item_name`";

$Recordset1 = mysql_query($query_Recordset1, $dbcon) or die(mysql_error());
$row_Recordset1 = mysql_fetch_assoc($Recordset1);
$totalRows_Recordset1 = mysql_num_rows($Recordset1);

我收到了这样的消息:

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'SELECT item_name, SUM(stock_invent) AS Total Items FROM inventories GROUP ' at line 1

Answer 1

use 命令在 phpMyAdmin(以及 mysql 的命令行工具)中用于选择要对其运行查询的数据库。在 PHP 中，您不应该需要它 - 这就是 mysql_select_db 的用途:

mysql_select_db('most', $dbcon);

$query_Recordset1 = "SELECT `item_name`, SUM(`stock_invent`) AS `Total Items` FROM inventories GROUP BY `item_name`";