mysql获取一个数组_如果没有结果显示消息，mysql获取数组

我正试图获得一个数据库调用来显示一个声明，说如果没有返回结果，就找不到结果。

我将如何去做到这一点我的代码： -

$getFixtures = mysql_query("SELECT ht.name AS hometeam_name, homescore, awayscore, at.name AS awayteam_name, time, date, week, comp.competition AS comp_name, se.name AS season_name

FROM fixture

JOIN team ht

ON ht.id = fixture.hometeam

JOIN team at

ON at.id = fixture.awayteam

JOIN competition comp

ON comp.id = fixture.competition

JOIN season se

ON se.id = fixture.season

WHERE se.name = '$season' AND comp.competition = '$competitiontitle' AND date >= '$today' AND at.name = '$teamName' OR ht.name = '$teamName' AND se.name = '$season' AND comp.competition = '$competitiontitle' AND date >= '$today'

ORDER BY date ASC

");

while ($fixtureData = mysql_fetch_array($getFixtures))

{

$hfixteamlink = strtolower(str_replace(" ","-",$fixtureData['hometeam_name']));

$afixteamlink = strtolower(str_replace(" ","-",$fixtureData['awayteam_name']));

$date = date("d/m/Y", strtotime($fixtureData['date']));

?>提前致谢

理查德