this is my query at the top, sorry
<?php
require_once("connect.php");
if(isset($_GET['userSearch'])) {
$srch=$_GET['userSearch'];
$allMov = "SELECT * FROM tbl_products WHERE products_name LIKE '%".
$srch."%' ORDER BY products_name";
} else if (isset($_GET['nav'])) {
$select=$_GET['nav'];
$allMov = "SELECT * FROM tbl_products, tbl_cat, tbl_l_pc WHERE tbl_products.products_id =tbl_l_pc.products_id AND tbl_cat.cat_id=tbl_l_pc.cat_id AND tbl_cat.cat_name = '".$select."' ORDER BY tbl_products.products_name ASC";
}
else{
$allMov = "SELECT * FROM tbl_products ORDER BY products_name ASC";
}
$movResults = mysql_query($allMov) or die (mysql_error());
?>