为MySQL结果设置用户变量(Setting a user variable for MySQL result)
我需要帮助设置MySQL结果的用户变量。
SELECT ptype, COUNT(ptype) FROM `TABLE 2` GROUP BY ptype ORDER BY COUNT(ptype)
我想为所有类型的结果值创建一个用户变量(TD = 5 ,DT = 13 ,...等)
我怎么会这样呢?
DW
<?$connector=mysqli_connect("localhost","", "",""); $res2=mysqli_query($connector, "SELECT ptype, COUNT(ptype) FROM `TABLE 2` GROUP BY ptype"); for (i = 0; i <12; i++) { $carrier[i] = while ($row=mysqli_fetch_array($res3)) {echo $row['COUNT(carrier)'];} }I need help with setting user variables for MySQL result.
SELECT ptype, COUNT(ptype) FROM `TABLE 2` GROUP BY ptype ORDER BY COUNT(ptype)
I would like to create a user variable for resulting value of all the types(TD=5,DT=13,...,etc)
How would I go about this?
dw
<?$connector=mysqli_connect("localhost","", "",""); $res2=mysqli_query($connector, "SELECT ptype, COUNT(ptype) FROM `TABLE 2` GROUP BY ptype"); for (i = 0; i <12; i++) { $carrier[i] = while ($row=mysqli_fetch_array($res3)) {echo $row['COUNT(carrier)'];} }最满意答案
尝试:
$ptype = array(); if($res2=mysqli_query($connector, "SELECT ptype, COUNT(ptype) AS pnum FROM TABLE 2 GROUP BY ptype")){ while($row=mysqli_fetch_array($res2)) { $ptype[] = $row['pnum']; } } else { printf("Error: %s\n", mysqli_error($connector)); }Try:
$ptype = array(); if($res2=mysqli_query($connector, "SELECT ptype, COUNT(ptype) AS pnum FROM TABLE 2 GROUP BY ptype")){ while($row=mysqli_fetch_array($res2)) { $ptype[] = $row['pnum']; } } else { printf("Error: %s\n", mysqli_error($connector)); }
更多推荐
发布评论