MYSQL:从一列中选择多个值


MYSQL: Select Multiple Values from one Column

>我有下表:

name -  catridge_type - department - date -     quantity
--------------------------------------------------------
Ak   -  Hp 305A Cyan  - IT         - 2016-01-13 - 5
Ad   -  Hp 508A Black - Hr         - 2016-02-13 - 6

我有以下选择语句:

$query= "SELECT catridge_type, quantity FROM catridge_details WHERE quantity > 0 ";

我的 select 语句返回catridge_type为空,但数量作为相应的值。

请协助。

附加代码:

$result = $db->query($query);
if(!$result) { die('Error getting Catridge types ['.$db->error.']' );}
else{
    //create an array to store the data
    $catridge_array = array();
    while ($row = $result->fetch_assoc()) {
        array_push($catridge_array, new available_catridges($row['catridges'], $row['quantity']));
            }
    header('Content-Type: application/json');
    echo json_encode($catridge_array);
        } 

$row['catridges']不存在。尝试使用$row['catridge_type']