searching cell for offerName!='' && offerName!=0...how to do that?

[spewn]

how do i write:

$stha = $dbha->prepare("select offerID from offers where ((offerType1 like '%$srchVar%')&&(offerType1 != ''))");

or

$sth = $dbh->prepare("select offerID, offerName, offerImgSmall, offerName2, offerType1, offerType2 from offers where ((offerType1 like '%$srchVar%')&&(offerType1 != '')) LIMIT $start, $results");

any ideas?

- g

 

[ericbrunson]

Change "&&" to "and"

And maybe read a tutorial on standard sql.

 

[r937]

if offertype1 is going to be like something non-empty (i.e. if $srchVar is not a zero-length string) then you don't really need to test for offertype1!=''

so all you need is

... where offertype1 like '%$srchVar%'

rudy | r937.com | Ask the Expert | Premium SQL Articles
SQL for Database-Driven Web Sites (next course starts May 8 2005)

 

[spewn]

wow...i didn't even test before i posted this question, so i messed up. you can actually write the code as i wrote it, and it works fine. sorry for the inconvenience.

- g