Can anyone help me figure this one out please.
I am trying to create a very simple search script using wildcards. User enters a keyword in a text field and submits that to this query
Code: Select all
<?php
$search = $_POST['search'];
$sqlqualsearch = "SELECT Qualification FROM allquals WHERE Qualification LIKE '% ".$search ." %'";
$rsqualsearch = mysql_query($sqlqualsearch);
while ($row = mysql_fetch_object($rsqualsearch))
{
echo $row['Qualification'];
}
?>For some reason my SQL doesn't work, yet the $search variable is passed via the $_POST etc..
Any help please, thanks in advance