I'm trying to use the code above but it doesn't work, so what is wrong? I have a submit button that posts to this script and a textbox called search. So when i hit submit it should post the contents of search to this script then the script displays the records which match the query.PHP Code:
$result = mysql_query("SELECT * FROM movie WHERE title LIKE $_REQUEST['search'] ORDER by title DESC");
if ($record = mysql_fetch_array($result)) {
do {
echo $record['title'] . "<br>\n";
} while ($record = mysql_fetch_array($result));
} else {
echo "No records found!";
}
what is wrong with my code?
Also I have a combo box with different colums that i can search by. How can i have it so when the info is posted, the text in the combo box called cats is posted and then depending on what is in the combo box it changes the query?
Reply With Quote