not null fields

[pietbez]

hi, i have a small problem here,

this code would work fine if the photourl table had numerical data, but the photourl table holds url info.

how can i change the code so that only those entries that have a photourl entries are read.

 

some of my photourl fields are empty, i want them exluded from the query.

 

$do=mysql_query ("SELECT * FROM links WHERE item = $item and photourl > 0" );

[flyhoney]

$do = mysql_query ("SELECT * FROM links WHERE item = $item and photourl IS NOT NULL");

[pietbez]

got it,

 

i was trying "photourl = NOT NULL"

 

thanks.