|
|
Posted by Jose Miguel on 08/22/05 04:04
We should use:
if (!empty($mydata->email))
in php, right?
On 8/19/05, Jasper Bryant-Greene <jasper@bryant-greene.name> wrote:
> John Taylor-Johnston wrote:
> > In php, if I wanted to know if $mydata->email contained something, I
> > would do this, right?
> > if ($mydata->email)
> > {}
> >
> > How would I express this in SQL (MySQL)?
>
> That doesn't tell you if $mydata->email contains something. It tells you
> whether the value of $mydata->email, when cast to boolean, equals TRUE.
> If $mydata->email equaled zero or the string "0", it would still contain
> something, but that if statement would not get executed.
>
> In MySQL, it would depend on the datatype. You could do any of the
> following, depending on what you actually want to do:
>
> colname<>''
> colname<>0
> colname IS NOT NULL
>
> Or, if you're in MySQL >= 5.0.2 and are using true boolean values:
>
> colname IS TRUE
>
> or, if you just want to check if it's TRUE or UNKNOWN:
>
> colname IS NOT FALSE
>
>
> Jasper
>
> --
> PHP General Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>
>
--
Jose Arce
http://sinexion.com - http://josearce.com
Navigation:
[Reply to this message]
|