Sql request "not null"

Question

I have table with colums id, name, email, message, phone, links and login. Login can be null(empty).

Its my sql request:

$dbh = new PDO("mysql:host=$dbHost;dbname=$dbName", $dbUser, $dbPassword); $sth = $dbh->query('SELECT * FROM `form` WHERE login NOT NULL '); $sth->setFetchMode(PDO::FETCH_ASSOC);

whith this error

 Call to a member function setFetchMode() on a non-object

Its error with "WHERE login NOT NULL", i know. How me correctly make this request?

You are getting a query error. use IS NOT NULL instead of NOT NULL — datasage
– datasage, Commented Jan 28, 2013 at 17:22
never assume a query has succeeded. ALWAYS check the return values from a DB operation. There's exactly ONE way for queries to succeed, and far far far too many ways for things to fail. — Marc B
– Marc B, Commented Jan 28, 2013 at 17:28

Raphaël Althaus · Accepted Answer · 2013-01-28 17:21:54Z

10

missing an IS

SELECT * FROM `form` WHERE login IS NOT NULL

answered Jan 28, 2013 at 17:21

Raphaël Althaus

60.6k6 gold badges106 silver badges127 bronze badges

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

Comments

moudrick · Accepted Answer · 2013-01-28 17:41:18Z

1

Try IS NOT NULL instead of just NOT NULL

edited Jan 28, 2013 at 17:41

answered Jan 28, 2013 at 17:22

moudrick

2,3661 gold badge25 silver badges34 bronze badges

Comments

EtherKnight · Accepted Answer · 2013-01-28 17:25:58Z

0

You're looking for:

"WHERE login IS NOT NULL"

answered Jan 28, 2013 at 17:25

EtherKnight

341 silver badge2 bronze badges

Collectives™ on Stack Overflow

Sql request "not null"

3 Answers 3

Comments

Comments

Comments

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Related