mysql 返回一行_mysql数据检索只返回一行

首先,很抱歉有一个很长的问题。。。但这让我头疼。任何帮助都会被广泛接受。

我编写了以下函数以从mysql数据库返回数据:

function injuryTable()

{

# get all players that are injured and their injuires...

$sql = "SELECT players.id, players.injury_id, players.pname, injuries_date.name, start_date, end_date

FROM players INNER JOIN injuries_date

ON injury_id = injuries_date.id";

$result = sqlQuery($sql);

return $result;

}

sqlQuery函数如下:

function sqlQuery($sql)

{

$products = array();

$link = dbConnect('localhost', 'root', '', 'umarrr');

$result = mysqli_query($link, $sql);

while ($row = mysqli_fetch_array($result))

{

$products[] = $row;

}

# return each row:

return $products;

#mysqli_close($link);

}

但是,