PHP/SQL Help

[ridikuloz]

What is the command to ignore empty values when you are queuering for results?

So far people have told me "SELECT colname FROM tablename WHERE colname IS NOT NULL" but that does not work. Anyone here can help me?

[wizzart]

SELECT colname FROM tablename WHERE colname IS NOT 0

NULL and 0 is not the same !

[ridikuloz]

nope doesn't work, gives me a syntax error.

[nestle]

Define what you mean by "ignore empty values". An empty value is simply '' (without single quotes).

If your colname is defined by NOT NULL and is completely empty:
SELECT colname FROM table WHERE colname != '';

If your colname has a NULL value in it:
SELECT colname FROM table WHERE colname <=> NULL;
or
SELECT colname FROM table WHERE colname IS NOT NULL;

[ridikuloz]

yeah, empty values, nothing, nada, no "null" just plain empty values.

[ridikuloz]

everything worked out, thanks alot!

[nestle]

everything worked out, thanks alot!

No problemo, it's what I do.