ok i figured out that last problem...but i have another...it now says error in my query
// call the file that initializes and sets all constants
require('inc.html');
// begin topnav
require('includes/topnav.html');
//end topnav
require('includes/breadcrumbs.html');
echo "
<!-- Body -->
<table width='760' border='0' cellspacing='0' cellpadding='0' style='width: 760px;'>
<tr>
<td width='168' valign='top'>";
//require('includes/leftnav.html');
echo " </td>
<td width='2'><img src='/images/spacer.gif' width='1' height='10' border='0' /><br><img src='/images/ccpixel.gif' width='1' height='98%' border='0' /></td>
<td valign='top'>";
$query = "SELECT *, MATCH(products_name, products_description, products_keywords, products_notes)
AGAINST ('".$_GET['query']."') AS score FROM products
WHERE MATCH(products_name, products_description, products_keywords, products_notes)
AGAINST ('".$_GET['query']."') ORDER BY score DESC";
$result = mysql_query($query) or die("Error in $query!");
echo "<div style='padding-top: 15px; padding-bottom: 70px;'>
<table width='590' border='0' cellspacing='0' cellpadding='0' style='width: 590px; padding-left: 20px;'>
<tr><td class='catTitle'>$prodhdr</td><td valign='top' style='padding-right: 10px;' align='right' class='smGray'>Showing <b>$start</b> - <b>$end</b> of <b>$numrows</b> Items Available </td></tr>
</table></div>
<table width='590' border='0' cellspacing='0' cellpadding='0' style='width: 590px; padding-left: 20px;'>
<tr>
<td><!-- Begin Product Filter -->
<div id='prodFilter' style='width: 570px; padding-left: 10px; padding-bottom: 7px; text-align: left;'>
Sort By: <a href='product.html?cid=$_GET[cid]&cparent=$_GET[cparent]&scid=$_GET[scid]&cname=".urlencode($_GET['cname'])."&sort=name'>Name/Brand</a> | Price: <a href='product.html?cid=$_GET[cid]&cparent=$_GET[cparent]&scid=$_GET[scid]&cname=".urlencode($_GET['cname'])."&sort=price'>Low To High</a> | <a href='product.html?cid=$_GET[cid]&cparent=$_GET[cparent]&scid=$_GET[scid]&cname=".urlencode($_GET['cname'])."&sort=size'>Size</a>
</div>
<!-- End Product Filter -->
</td>
</tr>
<tr>
<td>
<div style='background-color: #fff; border-top: 1px #333 solid; width: 570px;'>
<table width='570' border='0' cellspacing='0' cellpadding='0'>
</tr>
<tr style='line-height: 25px;'>
<td width='350' class='prodHDR' style='padding-left: 10px;'>Item</td>
<td class='prodHDR' width='110'>Price</td>
<td class='prodHDR' width='110'>Quantity</td>
<tr>
<td colspan='3'><img src='/images/ccpixel.gif' width='570' height='1' border='0' /></td>
</tr>
<tr><td colspan='3'><!-- Products Begin -->";
echo "<table width='570' border='0' cellspacing='0' cellpadding='0' style='width: 570px;'>";
while(list($prodid, $name, $mfg, $price, $msrp, $pda, $status, $sku, $weight) = mysql_fetch_array($result))
{
if ($pda>0) {
$yr=substr($row['pda'], 0, 4);
$dy=substr($row['pda'], 5, 2);
$mo=substr($row['pda'], 8, 2);
$pda=date("M d Y", mktime(0, 0, 0, $dy, $mo, $yr));
} else {
$pda="";
}
$netscname=urlencode($name);
if ($status==2) {
$outofstock="1";
}
else {
$outofstock="0";
}
if ($msrp!="0.00"&&$msrp!=$price) {
$isaving=$msrp-$price;
$diff=$msrp-$price;
$diffp=(1-($price/$msrp))*100;
$isaving=$diff;
}
$graphic="images/products/small/$sku.jpg";
if (!file_exists($graphic)) {
$graphic="/images/products/small/comingsoon.gif";
}
if (!isset($isaving)) {
$isaving="0.00";
}
echo " <form style='margin:0px;' action='shopping_cart.html' method='post'>
<tr><td id='prodlist' width='200' style='padding-left: 10px; padding-right: 5px;'><a href='product_detail.html?pid=$prodid&c=".$_GET['scid']."'>$name</a></td>
<td id='prodlist' width='130' style='padding-right: 5px; padding-left: 5px;' align='center'><img src='$graphic' border='0'></td>
<td id='prodlist' valign='top' width='110'><span class='msrpSM'>$$msrp</span> <span class='priceSM'>$$price</span></td>
<td id='prodlist' valign='top' width='120'>";
if ($outofstock=="0") {
echo "<input style='width:30px;' type='text' name='$prodid' value='' size='20'><br><br>
<input type='hidden' name='pid[]' value='$prodid'>
<input type='hidden' name='isaving_$prodid' value='$isaving'>
<input type='hidden' name='price_$prodid' value='$price'>
<input type='hidden' name='mfg_$prodid' value='$mfg'>
<input type='hidden' name='pname_$prodid' value='$name'>
<input type='hidden' name='sku_$prodid' value='$sku'>
<input type='hidden' name='pweight_$prodid' value='$weight'>
<input type='image' name='add_to_cart' value='Add To Cart' src='/images/add_to_cart_sm.gif'><br><br><span class='instock'>In Stock. Ready To Ship.</span>";
} else { echo"<span class='instock'>Out Of Stock.</span>"; } echo "</td>
</tr></form>
<tr><td colspan='4'><div style='border-bottom: 1px #cccccc solid; width: 570px; text-align: left;'></div></td></tr>";
}
echo "<tr><td colspan='4' align='right' style='padding-right: 10px; line-height: 20px;' valign='bottom' class='smGray'>";
if ($pageNum > 1)
{
$page = $pageNum - 1;
echo "<a href=\"$self?cid=$_GET[cid]&cparent=$_GET[cparent]&scid=$_GET[scid]&cname=$_GET[cname]&page=1\">First Page</a> - ";
echo "<a href=\"$self?cid=$_GET[cid]&cparent=$_GET[cparent]&scid=$_GET[scid]&cname=$_GET[cname]&page=$page\">Previous</a> - ";
}
if ($pageNum < $maxPage)
{
$page = $pageNum + 1;
echo "Page ".$pageNum." of ".$maxPage." ";
echo " <a href=\"$self?cid=$_GET[cid]&cparent=$_GET[cparent]&scid=$_GET[scid]&cname=$_GET[cname]&page=$page\">Next</a> - ";
echo "<a href=\"$self?cid=$_GET[cid]&cparent=$_GET[cparent]&scid=$_GET[scid]&cname=$_GET[cname]&page=$maxPage\">Last Page</a>";
}
else
{
$page = $pageNum + 1;
echo "Page <b>".$pageNum."</b> of <b>".$maxPage."</b> ";
}
echo "</td></tr>";
echo "</table></td></tr>
</table></div>
</td>
</tr>
</table>
</td>
</tr>
</table>
<!-- END Body -->
";
// begin footer
require('includes/footer.html');
// end footer
