Re: [PHP] php explained in sql

2005-08-21 Thread John Taylor-Johnston
varchar: colname<>'' Thanks, John Jasper Bryant-Greene 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

Re: [PHP] php explained in sql

2005-08-21 Thread Jose Miguel
We should use: if (!empty($mydata->email)) in php, right? On 8/19/05, Jasper Bryant-Greene <[EMAIL PROTECTED]> 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

Re: [PHP] php explained in sql

2005-08-19 Thread Jasper Bryant-Greene
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,