如何将MYSQL COUNT(*)语句的结果返回到HTML表中的单独列中

Question

如何将MYSQL ()语句的结果返回到HTML *中的单独列中

MYSQL - PHP

$sql= mysql_query("select count(*), shop_order_action from shop_orders o
                  WHERE shop_order_action IN ('Sale', 'Transfer', 'Delivery', 'Return')
                  AND shop_order_day = '28' AND shop_order_month = '08' AND shop_order_year = '2014'
                  AND shop_order_location = 'Bawtry'
                  GROUP BY FIELD (shop_order_action, 'Sale', 'Transfer', 'Delivery', 'Return')");


while ($row=mysql_fetch_row($sql)) {
echo "<pre>";
print_r($row);
echo "</pre>";

}

的PRINT_R结果

Array
(
    [0] => 8
    [1] => Sale
)
Array
(
    [0] => 2
    [1] => Transfer
)
Array
(
    [0] => 1
    [1] => Return
)

表

Shop Action    Count       

SALE           <? echo $row[0] ?> 
TRANSFER       <? echo $row[0] ?> 
DELIVERY       <? echo $row[0] ?>            
RETURN         <? echo $row[0] ?>

所以我需要返回正确的行值，即出售，转让.等在表中相应的列中。

我可以使用while循环来迭代结果，但是，我很难弄清楚如何构造循环，这样它就可以在while循环中按顺序打印出每一行，而不必转到循环的顶部。

也许我应该使用time循环和continue条件，这样每次回显$row时，它都会返回下一行。

Answer 1

我想出了一个可能不是最优的解决方案，但它可以按要求执行：

溶液

    $sql= mysql_query("select count(*), shop_order_action from shop_orders o
                  WHERE shop_order_action IN ('Sale', 'Transfer', 'Delivery', 'Return')
                  AND shop_order_day = '".$d."' AND shop_order_month = '".$m."' AND shop_order_year = '".$y."'
                  AND shop_order_location = 'Bawtry'
                  GROUP BY FIELD (shop_order_action, 'Sale', 'Transfer', 'Delivery', 'Return')");


while ($result=mysql_fetch_row($sql)) {

  if ($result[1] == 'Sale') { $sale = $result[0]; } 
  if ($result[1] == 'Transfer') { $transfer = $result[0]; } 
  if ($result[1] == 'Delivery') { $delivery = $result[0]; } 
  if ($result[1] == 'Return') { $return = $result[0]; } 

}
  if (isset($sale)) { echo $sale; }
  echo '<br />';
  if (isset($transfer)) { echo $transfer; }
  echo '<br />';

  etc ...

while循环中的代码将每个操作值存储为一个变量，该变量可以在循环之外调用。