RE: [PHP-WIN] Re: PHP Search DB Table

David, Sascha thank you both for your help. Using the query $query = "SELECT * FROM clients WHERE clientid = '$term'"; echo $query . '<br />'; $result = mysql_query($query); as suggested printed out the below SELECT * FROM clients WHERE clientid = '' This seems to indicate that it is not seeing the value within the single quotes. However a slight caveats to that If I change what is contained within the quotes to a specific number then it does read it, for example SELECT * FROM clients WHERE clientid = '123456'; So it is only when I enclose a value that it doesn't compute, I tried putting the $term within %% like so $query = "SELECT * FROM clients WHERE clientid = '%".$term"%'"; however this just returns we page not found, possibly because I need to use the LIKE parameter in there somewhere? Many thanks for all your help on this Kind Regards Oliver