这是我的查询:
$qry1 = "SELECT COUNT('name') FROM `brands` WHERE `catagory_id` = '".$id."';";
$res = mysqli_query($conn, $qry1);
我想要计数的值,并想在另一个查询中使用它。这怎么可能?
两个步骤:1.给count(name)
、total
计算的值取一个有意义的名称,例如。2.使用名称total
从1获取结果和访问值的第一行
$qry1 = "SELECT COUNT(name) as total FROM `brands` WHERE `catagory_id` = '".$id."';";
$count = $mysqli->query($conn, $qry1)->fetch_object()->total;
Try;
$qry1 = "SELECT COUNT(name) as counts FROM brands WHERE catagory_id = '".$id."';";
$res = mysqli_query($conn, $qry1);
$row = mysqli_fetch_array($res);
$count = $row["counts"];
现在这个$count变量保存了这个值。您可以在其他查询中包含此变量。