mysql fetch array if no results display message

Question

I am trying to get a database call to show a statement saying no results found if there are no results returned.

How would I go about doing this to my code:-

$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']));
                    ?>

thanks in advance

Richard

This smells like a good candidate for an if statement, if I ever saw any! — Lukas Eder
– Lukas Eder, Commented Jun 1, 2011 at 11:17

Richard Parnaby-King · Accepted Answer · 2011-06-01 11:21:15Z

4

This needs an IF statement.

$rows = mysql_fetch_array($getFixtures);
if(count($rows))
{
    while ($fixtureData = $rows)
    ...
}
else
{
    echo 'No results found';
}

answered Jun 1, 2011 at 11:21

Richard Parnaby-King

15k11 gold badges75 silver badges131 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

alex · Accepted Answer · 2011-06-01 11:19:07Z

3

if ( ! mysql_num_rows($getFixtures)) {
   echo 'No results found.';
} else {
  ...
}

answered Jun 1, 2011 at 11:19

alex

492k205 gold badges890 silver badges992 bronze badges

Collectives™ on Stack Overflow

mysql fetch array if no results display message

2 Answers 2

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related