Searching MYSQL Table using PHP???

[Anon]

I need a PHP script to search a MYSQL table and display output....i hve no idea how to do this..can someone please help me

thanks

[Anon]

Ok i got this working.......
but the problem is, its not searching the entire field......only the first word and not the whole string...how can i get it to search the whole string???

thanks

result = mysql_query ("SELECT * FROM test
WHERE file LIKE '$file%'
AND people LIKE '$people%'
AND des LIKE '$des%'
");

if ($row = mysql_fetch_array($result)) {
do {
print $row["file"];
print (" ");
print $row["people"];
print (" ");
print $row["des"];
print (" ");
} while($row = mysql_fetch_array($result));
} else {print "Sorry, no records were found!";}}

else { ?>

[Anon]

N/M PEOPLE...I GOT IT

THANKS