php - Getting undefined index while fetching column value from mysql

Question

I have the following code :

$sql = 'select count(*) from match as count where match_status != :status';
      $query = $con->prepare($sql);
      $query->bindValue(':status',LOST,PDO::PARAM_INT);
      $query->execute();
      $row = $query->fetch(PDO::FETCH_ASSOC);

      if(!empty($row))
        $row_count = $row['count'];
      else
        $row_count = 0;

I am getting Notice: Undefined index: count

What's the mistake?

Answer 1

You created the alias for the wrong thing. This should work:

SELECT count(*) as count FROM `match` WHERE match_status != :status
                 //^^^^^ Alias for 'count(*)' NOT for your table name

Also you have to put ` around keywords/Mysql reserved words e.g. match: http://dev.mysql.com/doc/refman/5.6/en/reserved-words.html

And if you turn on error mode then you also get an error for this, just put it right after your connection:

$con->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);