Please type in a keyword to begin your search.";
} else {
if (strlen($keyword) < 3){
echo "Your search must be atleast 3 characters.";
} else {
$limit=20; // rows to return
if (!$offset)
$offset = 0;
$goodcounter = $offset + 1;
if ($type)
$type = "AND cust1 = '$type'";
include 'subcats_catmap.php';
$numrows = mysql_num_rows(mysql_query("SELECT link_name, link_desc, inl_links.link_id, cust1, cust7, link_rating, link_votes, link_hits, cat_id FROM inl_links LEFT JOIN inl_custom ON inl_links.link_cust=inl_custom.cust_id LEFT JOIN inl_lc ON inl_links.link_id=inl_lc.link_id where $search_in like '%$keyword%' $type $catdrop group by link_name order by link_name"));
if ($numrows < 1) {
echo "no results, try again";
}
else {
$sqlquery = "SELECT link_name, link_desc, inl_links.link_id, cust1, cust7, link_rating, link_votes, link_hits, cat_id FROM inl_links LEFT JOIN inl_custom ON inl_links.link_cust=inl_custom.cust_id LEFT JOIN inl_lc ON inl_links.link_id=inl_lc.link_id where $search_in like '%$keyword%' $type $catdrop group by link_name order by link_name ASC LIMIT $offset,$limit";
$result = mysql_query($sqlquery);
$numcounter = ($offset + $limit);
if ($numcounter > $numrows)
{
$numcounter = $numrows;
}
$pages=intval($numrows/$limit);
if ($numrows%$limit){
$pages++;}
$pagenumber = ($offset / $limit) + 1;
$middle = ($offset + $limit) - 9;
?>
