/*CREATE TABLE IF NOT EXISTS `searchHits` (
`unique_ip` varchar(15) NOT NULL,
`prodId` int(5) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
*/
?>
include ('../../connect.php');
if(isset($_GET['qry']))
{
$qry = $_GET['qry'];
$sql = mysql_query("select id,name from products where name like '%$qry%' limit 10");
if(mysql_num_rows($sql)<1) die;
?>
while ($row = mysql_fetch_array($sql))
{
$id = $row[0];
$hitSQL = mysql_query("select prodId from searchHits where prodId='$id'");
$numHits = mysql_num_rows($hitSQL);
$name = $row[1];
echo '';
}
?>
}
else if(isset($_GET['uip']))
{
$ipToAdd = $_GET['uip'];
if(isset($_GET['i']))
{
$item = $_GET['i'];
$ipChecksql = mysql_query("select unique_ip,prodId from searchHits where unique_ip ='$ipToAdd' and prodId='$item'");
if(mysql_num_rows($ipChecksql) < 1)
$sql = mysql_query("insert into searchHits (unique_ip, prodId) values ('$ipToAdd','$item')");
}
}
?>