Well also, 0x00 != 0 and to test for NULL in mysql you need to use special functions IS NULL, IS NOT NULL etc.
Rodney Broom wrote: > > From: Andrew Hazen <[EMAIL PROTECTED]> > > > If it was blank, the sql statement would fail... > > Nope, you're passing an empty string with '$login'. NULL is not empty, it's less >that that. It's nothing. What you want is: > > emplogin=$login > > Rather than: > > emplogin='$login' > > > ...is SOMETIMES blank where is should be "Robyn". > > Yep, but I'll be that a query from the MySQL client never says the word NULL. > > --- > Rodney Broom > > --------------------------------------------------------------------- > Before posting, please check: > http://www.mysql.com/manual.php (the manual) > http://lists.mysql.com/ (the list archive) > > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- Colin Faber (303) 859-1491 fpsn.net, Inc. --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php