Question

select sum(order_count) from order_success where id=3;用PHP怎么将查询的数字取出来？

$sql="select sum(order_count) from order_success where `id`='3';
$result=mysql_query($sql);
while($rows=mysql_fetch_assoc($result))
{
print_r($rows);
}
用sql查询时字段名怎么成了[sum(order_count)]，其对应的值为9,怎么把9取出来赋给一个php变量?

Answer 1

1. 用sql查询时字段名怎么成了[sum(order_count)]

通常如此，当然你也可以修改SQL语句，自己提供一个名称。如以下示例：

$sql="select sum(order_count) as asum from order_success where `id`='3';

2. 怎么把9取出来赋给一个php变量?

$result=mysql_query($sql);
$rows=mysql_fetch_assoc($result);

echo $rows['asum'];

Answer 2

最好这样写sql语句
select sum(order_count) as total from order_success where id=3;
$result=mysql_query($sql);
while($rows=mysql_fetch_assoc($result))
{
$order_total = $row['total '];
}