Thank you - I did try that as well but I still get no results. Using this method I do get results if I have a value in each of the 3 fields - even if there is only part of the field in the search - but if any one of them is empty in the url string I get no results.
For example
searchresults.php?S_Name=geo&S_Tel=1&S_Email=g&Search3=Search - this works but
searchresults.php?S_Name=geo&S_Tel=&S_Email=&Search3=Search - this doesn't work
I have even tried
$booking = new WA_MySQLi_RS("booking",$georgeconnect_i,0);
$booking->setQuery("SELECT carpark.*, contractcar.ContractID FROM carpark LEFT JOIN contractcar ON carpark.CarID=contractcar.ID WHERE Company='Ascars' AND carpark.email LIKE CONCAT('%%',?,'%%') AND carpark.name LIKE CONCAT('%%',?,'%%') AND Tel LIKE CONCAT('%%',?,'%%') ORDER BY Date DESC");
$booking->bindParam("c", "".$_GET['S_Email'] ."", "-1"); //colname1
$booking->bindParam("c", "".$_GET['S_Name'] ."", "-1"); //colname2
$booking->bindParam("c", "".$_GET['S_Tel'] ."", "-1"); //colname3
$booking->execute();
But if any one of the values is empty in the url string I get no results
