Query problem????

[Anon]

Hi all,
I have the following code:

$sql="SELECT * FROM $table WHERE $searchtype OR $searchtype1 LIKE '%$searchstring%' AND Info != '' AND description != '' ORDER BY CatName ASC";

At the moment it is only querying $searchtype1. How do i get it to search both $searchtype and $searchtype1?

Cheers,
maccam

[greyfox]

There is a problem with your OR and AND statement. A more strict compiler would tel this problem to you normally.

$searchtype OR $searchtype1 LIKE '%$searchstring%'

should be

$searchtype LIKE '%$searchstring%' OR $searchtype1 LIKE '%$searchstring%'

in your case, the compiler thinks it should check whether $searchtype is TRUE or not..

Furthermore, use parenthesis to avoid mixups:

$sql="SELECT * FROM $table WHERE (($searchtype LIKE '%$searchstring%') OR ($searchtype1 LIKE '%$searchstring%')) AND (Info != '') AND (description != '') ORDER BY CatName ASC";

[yurko]

...checking for NULL:
Info != ''
Info IS NOT NULL