Posted by Homechoice on 12/04/05 11:19

Here bis something that is not working and I cannot figure out why.

I have a mySQL query that is something like

select * from customers where firstname LIKE "%$pram1%" AND town LIKE "%
$param2".

Providing Param 1 and 2 contain values all is well. However if they are
blank (which accoring to my logic should mean the like becomes anything)
it does not work.

Any ideas please? I just want to pass a blank parameter

[Back to original message]