How to check if $row['column_name'] is returning empty php mysql

Question

I have a table with columns

id,name,phone,describe

While fetching the values from this table i am using

$row=mysql_fetch_array($query) 

Now i want to check whether

$row['describe'] 

is returning empty value. How to check in php??

Answer 1

You can use ==0, this will check if it equals to 0:

if ($row['describe']==0) { /* code to do */ }

Or empty(), this will check if it is empty:

if (empty($row['describe'])) { /* code to do */ }

Personally, I would prefer !empty() as this will check if the variable is empty.

Hope this helps, thanks!

Answer 2

Try this :

if(empty($row['describe'])) {
    //$row['describe'] is empty
} else {
    //$row['describe'] is not empty
}

Also please dont use mysql_*. It's deprecated and removed from PHP 7. Use mysqli_* or PDO.