Is null in php mysql?

Here is the below Code:

$query = mysql_query("SELECT * FROM tablex");

if ($result = mysql_fetch_array($query)){

    if ($result['column'] == NULL) { print ""; }
    else { print ""; }
}

If the values are NOT NULL i still get the uncheked box. Am i doing something wrong from above, shoudnt $result['column'] == NULL work?

Any Ideas?

asked Oct 16, 2009 at 5:33

Angel.King.47Angel.King.47

7,79414 gold badges59 silver badges84 bronze badges

4

Use is_null or === operator.

is_null($result['column'])

$result['column'] === NULL

answered Oct 16, 2009 at 5:42

The ChairmanThe Chairman

7,0362 gold badges37 silver badges43 bronze badges

1

How about using

if (empty($result['column']))

answered Oct 16, 2009 at 5:53

fernybfernyb

9731 gold badge8 silver badges11 bronze badges

2

Make sure that the value of the column is really NULL and not an empty string or 0.

answered Oct 16, 2009 at 5:46

Tomas MarkauskasTomas Markauskas

11.3k2 gold badges32 silver badges35 bronze badges

2

I think you want to use

mysql_fetch_assoc($query)

rather than

mysql_fetch_row($query)

The latter returns an normal array index by integers, whereas the former returns an associative array, index by the field names.

answered Oct 16, 2009 at 5:42

JoelJoel

11.2k17 gold badges61 silver badges72 bronze badges

1

Sometimes, when I know that I am working with numbers, I use this logic (if result is not greater than zero):

if (!$result['column']>0){

}

answered Dec 5, 2015 at 19:58

AndrewAndrew

7,46113 gold badges59 silver badges114 bronze badges

1

This MySQL tutorial explains how to use the MySQL IS NULL condition with syntax and examples.

Description

The MySQL IS NULL Condition is used to test for a NULL value in a SELECT, INSERT, UPDATE, or DELETE statement.

Syntax

The syntax for the IS NULL Condition in MySQL is:

expression IS NULL

Parameters or Arguments

Note

• If expression is a NULL value, the condition evaluates to TRUE.
• If expression is not a NULL value, the condition evaluates to FALSE.

Example - With SELECT Statement

Let's look at an example of how to use MySQL IS NULL in a SELECT statement:

SELECT *
FROM contacts
WHERE last_name IS NULL;

This MySQL IS NULL example will return all records from the contacts table where the last_name contains a NULL value.

Example - With INSERT Statement

Next, let's look at an example of how to use MySQL IS NULL in an INSERT statement:

INSERT INTO contacts
(contact_id, contact_name)
SELECT account_no, supplier_name
FROM suppliers
WHERE category IS NULL;

This MySQL IS NULL example will insert records into the contacts table where the category contains a NULL value.

Example - With UPDATE Statement

Next, let's look at an example of how to use MySQL IS NULL in an UPDATE statement:

UPDATE contacts
SET last_name = 'TBD'
WHERE last_name IS NULL;

This MySQL IS NULL example will update records in the contacts table where the last_name contains a NULL value.

Example - With DELETE Statement

Next, let's look at an example of how to use MySQL IS NULL in a DELETE statement:

DELETE FROM contacts
WHERE last_name IS NULL;

This MySQL IS NULL example will delete all records from the contacts table where the last_name contains a NULL value.

Is NULL in MySQL?

Is NULL in PHP?

IS NOT NULL php MySQL?

Is NULL or empty MySQL?