php mysql fetch ascco_MySQL / PHP mysql_fetch_array()保持缺少第一行

大家好！

出于某种原因，Database :: fetchArray()正在跳过查询结果集的第一行。

它正确地打印所有行，只是由于某种原因不断丢失第一行，我假设我的fetchArray()函数有问题？

我在phpMyAdmin中运行了查询，它返回了4行，当我在PHP文件(下面的代码)的本地主机上尝试它时，它只使用相同的'WHERE tunes.riddim'-value of course创建3行。 google上大多数类似的主题表明，一个常见的错误是在while()之前使用mysql_fetch_array()，它将指针设置在前面并导致第一行丢失，不幸的是我只有一个mysql_fetch_array()调用而() - 头)。

$db->query("SELECT " .

"riddims.riddim AS riddim, " .

"riddims.image AS image, " .

"riddims.genre AS genre, " .

"tunes.label AS label, " .

"tunes.artist AS artist, " .

"tunes.tune AS tune, " .

"tunes.year AS year," .

"tunes.producer AS producer " .

"FROM tunes " .

"INNER JOIN riddims ON tunes.riddim = riddims.riddim " .

"WHERE tunes.riddim = '" . mysql_real_escape_string(String::plus2ws($_GET['riddim'])) . "'" .

"ORDER BY tunes.year ASC");

$ar = $db->fetchArray();

for($i = 0; $i < count($ar) - 1; $i++)

{

echo $ar[$i]['riddim'] . " - " . $ar[$i]['artist'] . " - " . $ar[$i]['tune'] . " - " . $ar[$i]['label'] . " - " . $ar[$i]['year'] . "
";

}

?>Database :: fetchArray()看起来像：

public function fetchArray()

{

$ar = array();

while(($row = mysql_fetch_array($this->result)) != NULL)

$ar[] = $row;

return $ar;

}任何建议感激！