运行脚本时出现错误

Question

请在执行此脚本时收到此错误代码警告: mysql_fetch_assoc()：在第47行的/home/a777gqka/public_html/testserver/index.php中，提供的参数不是有效的MySQL结果资源

$query = mysql_query("SELECT
e.id,
ts.name AS stage_name,
DATE_FORMAT(e.startdate, '2013-05-15') AS startdate,
DATE_FORMAT(e.startdate, 'H:i') AS starttime,
MIN(if( ep.number = 1, p.name, NULL)) AS home_team,
if(e.status_type = \"notstarted\", \"-\",(MIN(if(ep.number = 1, r.value, NULL))))  AS home_score,
if(e.status_type = \"notstarted\", \"-\",(MIN(if(ep.number = 2, r.value, NULL)))) AS away_score,
MIN(if(ep.number = 2, p.name, NULL)) AS away_team,
es.name AS status_text
FROM
tournament_template AS tt INNER JOIN
tournament AS t ON t.tournament_templateFK = tt.id INNER JOIN
tournament_stage AS ts ON t.id = ts.tournamentFK INNER JOIN
event AS e ON ts.id = e.tournament_stageFK INNER JOIN
event_participants AS ep ON e.id = ep.eventFK LEFT JOIN
status_desc AS es ON e.status_descFK = es.id LEFT JOIN
participant AS p ON ep.participantFK = p.id LEFT JOIN
result AS r ON ep.id = r.event_participantsFK AND r.result_code = \"runningscore\" LEFT JOIN
property AS prop ON e.id = prop.objectFK AND prop.object =\"event\" AND prop.name = \"Live\"
WHERE
tt.sportFK = ".$sportFK."  AND
e.startdate BETWEEN ".$TODAY_FROM." AND ".$TODAY_TO." AND
prop.value = \"yes\"
GROUP BY
e.id
ORDER BY 
ts.id, e.startdate, e.id");
while($row = mysql_fetch_assoc($query)){
// Do something
}

Answer 1

 $query = "SELECT .... ";
 if($result = mysql_query($query)){
     while($row = mysql_fetch_assoc($result)){
          //...
     }
 } else {
     echo mysql_error();
 }

除了你应该输出你的错误之外，你至少应该使用mysqli。mysql_*函数已弃用，将从PHP5.5中删除。

Answer 2

您没有执行查询。

在while循环之前添加$result = mysql_query($query)，并将循环测试更改为$row = mysql_fetch_assoc($result)

此外，mysql_*函数已被弃用，并将在将来的更新中删除。切换到mysqli_*或PDO。

我个人建议使用PDO。

Answer 3

$query = mysql_query("SELECT...") or die(mysql_error());
if ($query){
while($row = mysql_fetch_assoc($query)){
// Do something
}
}