[SOLVED] NULL values

[TLawrence]

I'm currently having a problem with NULL values being returned from a MS SQL query.  The query grabs all the information from a table (news):

 

$nextRecord = mssql_query("select * from news");

 

The 'news' table has five columns: id, title, date, content, and picture.  The 'picture' column may or may not have a value.  Once I run the query I'm using the list command in conjunction with mssql_fetch_row to go through the result:

 

while(list($id,$title,$date,$content,$picture) = mssql_fetch_row($nextRecord)) {

 

There is an if statement that determines the code to execute depending if $picture has a value or not:

 

if($picture) {

code....

} else {

code....

}

 

The problem is the first part of the if statement always runs, even if $picture does not have a value.  This code works without a problem on a mySQL server, so I'm thinking it has something to do with the MS SQL server.  Has anyone come across this or know how to correct the problem?  Is there a setting I'm overlooking regarding the server/database?

 

Any help would be greatly appreciated.

 

Tjay35

[rhodesa]

try

if(strlen(trim($picture))){

}