[Resolved] query problem

[Boudga]

I have a form that has a text box named "input" and when it submits using a PHP script I can't figure out how to search each field in my table for records that contain the "input" text...I've tried what follows but it doesn't work. Is there a simpler way to search each field also? Like maybe with an array...if so how could I create that array?

$query = mysql_query
("
SELECT partnum , nsn , description , top_level_kit , eng_used_on , actcage
FROM $usertable
WHERE partnum
LIKE '%$input%' OR nsn
LIKE '%$input%' OR description
LIKE '%$input%' OR top_level_kit
LIKE '%$input%' OR eng_used_on
LIKE '%$input%'

ORDER BY partnum ASC
") or die (mysql_error());

[stolzyboy]

that should do it, what is the problem

[Boudga]

when I run this query it returns all records unless of course I LIMIT it...instead of returning the value of the variable $input

[barand]

Try

$sql = "SELECT `partnum` , `nsn` , `description` , `top_level_kit` , `eng_used_on` , `actcage` 
FROM $usertable 
WHERE `partnum` 
LIKE '%$input%' OR `nsn` 
LIKE '%$input%' OR `description` 
LIKE '%$input%' OR `top_level_kit` 
LIKE '%$input%' OR `eng_used_on` 
LIKE '%$input%' 
ORDER BY `partnum` ASC ";

echo $sql;

From your symptoms, it sounds as though $input = ''

hth