Exclude Null Columns

[plasmahba]

Hi everybody!

I have been searching a way to exclude the NULL columns from my database when I make a query but I haven`t figure out how to do it right.

Any help is greatly appreciated

This is my code

$results = mysql_db_query ("$DbName","SELECT * from myDB WHERE ID='$ID' AND ID <> NULL ");

or

$iconos = mysql_db_query ("$DbNombre","SELECT * from availres WHERE ID='$ID' AND ID IS NOT NULL ");

Any idea?

Thanxs

[plasmahba]

Somo more info about it

What I actually want to do with this, is to only show the images linked in my database and exclude the ones with null values so I won`t see the "missing picture" icon in my navigator

Thanxs

[plasmahba]

Is this possible to do?

I have a "description page" where you can see different features of an item. In this case, some items will show some "images" depending if they are linked by an URL through mySQL db.
http://localhost/mysite/images/image1.jpg for example

So depending if the column has the url of the image it will show, otherwise the value IS NULL.

Now, I put in my description page all the "img src" of all the images expecting to get all the images where they exist and excluding the ones that doesn´t exist for that item but I get always the "missing picture x" of the explorer where the values are NULL.

I have made this

$iconsr = mysql_db_query ("$DbName","SELECT * from icons WHERE IDres='$ID' AND IDres IS NOT NULL ");

Is there a way to exclude those images so they won`t show as missing?

Any help is greatly appreciated