为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));
}