Search Problem

[pdn]

My search function isn't working properly... I will do a search where I know there should be multiple results but it does not show all of the results it should only a few select ones.

here is the code

<!-- Search form --> 
<form action="<?php echo $_SERVER['PHP_SELF']; ?>" method="get"> 
<input type="text" name="search_text" size="50" maxlength="50"><input type="submit"> 
</form> 
<?php  

$sql = " 
    SELECT Name, AKA, DOB, Address, Conviction, Description, Victim, Comments, Pic 
    FROM sexoffenders 
";  

// If search_text has been sent ... 
if(isset($_GET['search_text'])){  

    $sql .= " 
    WHERE CONCAT(Name,' ',AKA,' ',Address,' ',Conviction,' ',Description,' ',Victim,' ',Comments,' ') LIKE 

'%".$_GET['search_text']."%' 
";  

}  



Thanks in advance for any help

[JHobbs]

I have found the SQL "Like" statement to be very unreliable. I always use:

Where (Value2Test >= Value) AND
(Value2Test < Value + x)

You'll have to format it for your PHP script but I use this always for testing for a string value and it's worked well for me

For some good articles on PHP bye-the-way see this link:
http://www.findingfacts.com/L3/L3_2_29_46.php