Ok im making a little search script that just searches a mysql database, thing is Im getting a error which i cannot figure out, you know those damn brain farts, so i need a little help here is the code I hope you can spot the problem, thanx
<?
//Start Page after user clicks search
if ($_REQUEST["Submit"] == "Search") {
if ($_REQUEST["searchtxt"] == "") {
//check to see if form is blank
echo "<b><font color=red><Center>Field was left blank!</center></font></b>";
form();
return;
}
//show search form
form();
//Start Database Connections and search
require("../cfg.php");
//Connection to mysql database
$connect = mysql_connect($hostname, $user_name, $user_pass) or die ("<b><center>".mysql_errno().": ".mysql_error()."</b></center>\n");
$db = mysql_select_db($database, $connect) or die ("<b><center>".mysql_errno().": ".mysql_error()."</b></center>\n");
$sql = "SELECT * FROM ".$ext."goods LIKE ".$ext."Brand = '%".$_REQUEST["searchtxt"]."%'";
$query = "SELECT COUNT(*) FROM ".$ext."goods LIKE ".$ext."Brand = '%".$_REQUEST["searchtxt"]."%'";
$numguests = mysql_query($query) or die ("<b><center>".mysql_errno().": ".mysql_error()."</b></center>\n");
$numguest = mysql_fetch_array($numguests);
$result = mysql_query($sql, $connect) or die ("<b><center>".mysql_errno().": ".mysql_error()."</b></center>\n");
?>
<br><span class="select"> Search Results: <? echo $numguest[0]; ?> Found!</span><br><br>
<?
$table_color2 = "#D3DEEB";
$table_color1 = "#EEF2F7";
$row_count = "0";
while ($row = mysql_fetch_array($result)){
$row_color = ($row_count % 2) ? $table_color1 : $table_color2;
$count = ($row_count + 1);
?>
<table width="640" border="0" cellspacing="0" cellpadding="0">
<tr>
<td><table width="100%" border="0" align="center" cellpadding="0" cellspacing="1">
<tr bgcolor="<? echo "$row_color"; ?>">
<td width="3%" rowspan="3" align="left" valign="top" class="select"><? echo $count; ?></td>
<td width="97%" colspan="4" class="select">Product: <? echo $row[$ext."Brand"]; ?></td>
</tr>
<tr bgcolor="<? echo "$row_color"; ?>">
<td colspan="4" class="txt"><span class="select">Description:</span>
<? echo $row[$ext."Desc"]; ?></td>
</tr>
<tr bgcolor="#FFFFFF" class="txt">
<td colspan="4"><table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr class="slinkage">
<td nowrap><span class="select">Sku:</span> <? echo $row[$ext."paypal"]; ?></td>
<td nowrap><span class="select">Make:</span> <? echo $row[$ext."Manufactory"]; ?></td>
<td nowrap><span class="select">Category:</span> <? echo $row[$ext."Category"]; ?></td>
<td nowrap> <span class="select">Price:</span> <? echo $row[$ext."Price"]; ?></td>
</tr>
</table></td>
</tr>
</table></td>
</tr>
</table>
<br>
<?
$row_count++;
}
mysql_close($connect);
return;
}
?>
here is the error message
1064: You have an error in your SQL syntax near 'LIKE DA_Brand = '%e%'' at line 1
