NULL as nothing, but Data as links

[djsimple007]

I cant get this to work=
Ive gotten to the point where it shows a link no matter what, even if there is no data, but Id like to put in an if else loop so if theres no data it just echoes 'NONE'
This is my knarly code that wont work======

if ($row_Recordset1['emailwork2']; != "")
{ <a href="mailto:<?php if
($row_Recordset1['emailwork2']; != "") echo $value; ?>">None</a>
} else ($row_Recordset1['emailwork2']; != "['emailwork2']") {
<a href="mailto:<?php echo $row_Recordset1['emailwork2']; ?>">E-Mail
Work 2</a>
}

[Sxooter]

Is it really a NULL that's being stored? If so, look at isnull:

http://us2.php.net/manual/en/function.is-null.php
Note that some db layers support a db_isnull function as well.