Re: Searchbox values do not work correctly

[David Powers]

David Powers wrote:
> if (isset($_GET['PropType']) && in_array($_GET['PropType'], $propTypes)) {
>   $PropType = "= '".$_GET['PropType']."'";
> } else {
>   $PropType = 'LIKE %';
> }

I missed out the quotes around the wildcard character. Change the 
preceding section to this:

if (isset($_GET['PropType']) && in_array($_GET['PropType'], $propTypes)) {
  $PropType = "= '".$_GET['PropType']."'";
} else {
  $PropType = "LIKE '%'";
}

--
David Powers, Adobe Community Expert
Author, "The Essential Guide to Dreamweaver CS3" (friends of ED)
Author, "PHP Solutions" (friends of ED)
http://foundationphp.com/