Friday, December 07, 2001, 5:18:38 AM, Aaron Shurts wrote:
AS> Okay, I was the one that asked the crazy question about the weird join,
AS> but I got that figured out. Now I have a problem.
AS> while( ($login, $existingemail, $areacode, $prefix, $rest) =
$sth->>fetchrow_array ())
AS> {
AS>
Hello Aaron,
Friday, December 07, 2001, Aaron Shurts <[EMAIL PROTECTED]> wrote:
AS> Okay, I was the one that asked the crazy question about the weird join,
AS> but I got that figured out. Now I have a problem.
AS> while( ($login, $existingemail, $areacode, $prefix, $rest) =
$sth->>fetchrow_arr
Oracle has an NVL command such that you can say:
select NVL( email, "NO EMAIL PROVIDED" )
from table;
and if email is NULL then NO EMAIL PROVIDED will be returned.
I know that mySQL has a similar mechanism, but I don't know what it is
called (it might be NVL). I would try to do that.
-O
