Hi I'm trying to pull upcoming fixtures of a sports team from my database. I'm using the following code to get the data:
I was wondering how I would display a message saying there are no upcoming fixtures if this returns nothing?
Code:
$sql = "SELECT * FROM `fixtures` WHERE `Date` > CURDATE()";
$result=mysql_query($sql);
$level=mysql_result($result,0,"Level");
$date=mysql_result($result,0,"Date");
$opponent=mysql_result($result,0,"Opponent");
$venue=mysql_result($result,0,"Venue");
$time=mysql_result($result,0,"Time");
$crest=mysql_result($result,0,"Crest");
?>
I was wondering how I would display a message saying there are no upcoming fixtures if this returns nothing?