两个查询，两个结果来自sql试图在php中划分它们

Question

我有来自sql的两个计数查询。我想把这两个查询的结果分开。我试过：

    $con = mysqli_connect("localhost", "root", "", "xoxo") or die(mysqli_connect_error());

    $query = "SELECT COUNT(xxxx) AS a zzzz";

    $query1 = "SELECT COUNT(xxxx) AS b FROM zzzz WHERE xxxx = 'cccc'";


    $result = mysqli_query($con, $query) or die('Error querying database');
    $result1 = mysqli_query($con, $query1) or die('Error querying database');

    $row = mysqli_fetch_array($result);
    $rowa = mysqli_fetch_array($result1);

    $x = $row/$rowa;

    echo $x;

但它告诉我，它有一个致命的错误。

$con=mysqli_connect（“localhost”、“root”、“xoxo”）或die（mysqli_connect_error（））；

    $query = "SELECT COUNT(xxxx) AS row1 FROM zzzz";

    $query1 = "SELECT COUNT(xxxx) AS row2 FROM zzzz WHERE xxxx = 'cccc'";

    $result = mysqli_query($con, $query) or die('Error querying database');
    $result1 = mysqli_query($con, $query1) or die('Error querying database');


    while ($row = mysqli_fetch_array($result)) {

    }

    while ($row1 = mysqli_fetch_array($result1)) {

    }

    echo (int)($row['row1'] / $row1['row2']);

但它告诉我这是一个零除。然而，我的第1行和第2行对它都有价值。

Answer 1

您已经在中初始化了两个查询的结果，而循环

试试这个

 $row = mysqli_fetch_array($result);
 $row1 = mysqli_fetch_array($result1);

echo (int)($row['row1'] / $row1['row2']);

Answer 2

当您使用while循环时，意味着它将循环直到条件为false，这意味着您的$row和$row1都为false。您需要的是：

$query = "SELECT COUNT(xxxx) AS row1 FROM zzzz";

$query1 = "SELECT COUNT(xxxx) AS row2 FROM zzzz WHERE xxxx = 'cccc'";

$result = mysqli_query($con, $query) or die('Error querying database');
$result1 = mysqli_query($con, $query1) or die('Error querying database');

$row = mysqli_fetch_array($result);
$row1 = mysqli_fetch_array($result1);

echo (int)($row['row1'] / $row1['row2']);

您的第一个示例没有工作，因为当您执行$row/$rowa时，您试图划分2个数组...