PHP: How to check if no rows are returned

Question

With the following PHP code, how do i check if there's no row retuned so i can echo some message?

PHP:

<?php 
    require_once 'db_conx.php';
    $Result = mysql_query("SELECT * FROM ads WHERE pid = '2'")
        or die (mysql_error());
    while($row = mysql_fetch_array($Result)){
        echo '<span class="classPid" style="display:none">'.$row['pid'].'</span>';
    }
?>

Thanks

possible duplicate of [PHP and MySQL: Number of rows returned](http://stackoverflow.com/questions/5140298/php-and-mysql-number-of-rows-returned) — Matsemann, Dec 08 '13 at 10:03

score 3 · Answer 1 · answered Dec 08 '13 at 10:07

3

There are a number of ways to do this. There is a specific function mysql_num_rows() which will return the number of rows returned.

mysql_num_rows($Result);

This will return 0 if there are no rows affected or returned.

You could also create some conditions using mysql_fetch_array. mysql_fetch_array will return FALSE if there are no rows.

On a separate note it would be a good idea to update your connection and functions to mysqli as mysql is no depreciated.

See docs on mysql_num_rows().

http://www.php.net/mysql_num_rows

answered Dec 08 '13 at 10:07

Dane Caswell

201
5
9

2

That's a good answer too, but you know the JQuery generation always goes for short solutions. – Relm Dec 08 '13 at 15:45
This is the best approach but mysql_num_rows($Result); has been deprecated and removed since PHP 7.0 Instead use: mysqli_num_rows() OR mysqli_stmt_num_rows() OR PDOStatement::rowCount() See the linked PHP documents for details. @Dane Caswell, I'll leave any editing to you. Due to SOs SEO this answer is still a top Google hit. – Shaedo Oct 21 '19 at 06:07

score 2 · Accepted Answer · edited Dec 08 '13 at 10:12

2

Something like this

<?php 
    require_once 'db_conx.php';
    $Result = mysql_query("SELECT * FROM ads WHERE pid = '2'")
        or die (mysql_error());
    $i=0;
    while($row = mysql_fetch_array($Result)){
        echo "<span class='classPid' style='display:none'>".$row['pid']."</span>";
        $i++;
    }
    if($i==0){
        echo "No rows found";
    }
?>

edited Dec 08 '13 at 10:12

Jaak Kütt

2,566
4
31
39

answered Dec 08 '13 at 09:43

Shankar Narayana Damodaran

68,075
43
96
126

1

Why didn't you suggest `mysql_num_rows`? – Konsole Dec 08 '13 at 10:10
@Console, Calling a `function` is quite expensive. – Shankar Narayana Damodaran Dec 08 '13 at 10:29
1

@ShankarDamodaran Simple and short, what do you mean functions are expensive? – Relm Dec 08 '13 at 15:44

PHP: How to check if no rows are returned

2 Answers2