[opgelost] Update query werkt niet goed

<?
$objDb = new Db();
$today = mktime (0, 0, 0, date("m"), date("d"), date("Y"));
$ip = getIp();

// controle of er vandaag al bezoekers zijn geweest
$strQuery = "
	SELECT
		*
	FROM
		`".DB_PREFIX."stats_overview`
	WHERE
		`stats_date` = ".$today."
	LIMIT 1
";

if(($objResult = $objDb->query($strQuery, true)) != null)
{
	// er is al bezoek geweest vandaag, controle of deze bezoeker al online geweest is	
	$strQuery = "
		SELECT
			*
		FROM
			`".DB_PREFIX."stats_pageviews`
		WHERE
			`pageview_ip` = '".$ip."'
		AND
			`pageview_date` >= ".$today."
		LIMIT 1
	";
	
	if(($objResult = $objDb->query($strQuery, true)) == null)
	{
		// bezoeker is nog niet geweest, update stats_overview
		$strQuery = "
			UPDATE
				`".DB_PREFIX."stats_overview`
			SET
				`stats_unique` = `stats_unique`+1
			AND
				`stats_pageviews` = `stats_pageviews`+1
			WHERE
				`stats_date` = ".$today."
		";
	}
	else
	{
		$strQuery = "
			UPDATE
				`".DB_PREFIX."stats_overview`
			SET
				`stats_pageviews` = `stats_pageviews`+1
			WHERE
				`stats_date` = ".$today."
		";	
	}
	
	$objDb->query($strQuery, false);
	$objDb->close();
}
else
{
	// er is nog geen bezoek geweest vandaag
	$strQuery = "
		INSERT INTO
			`".DB_PREFIX."stats_overview`
			
			(`stats_date`, `stats_pageviews`, `stats_unique`)
		VALUES
			(".$today.", 1, 1)
	";
	
	$objDb->query($strQuery, false);
	$objDb->close();
}


//update pageviews
$strQuery = "
	INSERT INTO
		`".DB_PREFIX."stats_pageviews`
		
		(`pageview_ip`, `pageview_date`)
	VALUES
		('".$ip."', ".time().")
";

$objDb->query($strQuery, false);
$objDb->close();
?>

<?
$objDb = new Db();
$today = mktime (0, 0, 0, date("m"), date("d"), date("Y"));
$ip = getIp();
 
// controle of er vandaag al bezoekers zijn geweest
$strQuery = "
	SELECT
		*
	FROM
		`".DB_PREFIX."stats_overview`
	WHERE
		`stats_date` = ".$today."
	LIMIT 1
";
 
if(($objResult = $objDb->query($strQuery, true)) != null)
{
	// er is al bezoek geweest vandaag, controle of deze bezoeker al online geweest is	
	$strQuery = "
		SELECT
			*
		FROM
			`".DB_PREFIX."stats_pageviews`
		WHERE
			`pageview_ip` = '".$ip."'
		AND
			`pageview_date` >= ".$today."
		LIMIT 1
	";
 
	if(($objResult = $objDb->query($strQuery, true)) == null)
	{
		// bezoeker is nog niet geweest, update stats_overview
		$strQuery = "
			UPDATE
				`".DB_PREFIX."stats_overview`
			SET
				`stats_unique` = `stats_unique`+1
			AND
				`stats_pageviews` = `stats_pageviews`+1
			WHERE
				`stats_date` = ".$today."
		";
	}
	else
	{
		$strQuery = "
			UPDATE
				`".DB_PREFIX."stats_overview`
			SET
				`stats_pageviews` = `stats_pageviews`+1
			WHERE
				`stats_date` = ".$today."
		";	
	}
 
	$objDb->query($strQuery, false);
	$objDb->close();
}
else
{
	// er is nog geen bezoek geweest vandaag
	$strQuery = "
		INSERT INTO
			`".DB_PREFIX."stats_overview`
 
			(`stats_date`, `stats_pageviews`, `stats_unique`)
		VALUES
			(".$today.", 1, 1)
	";
 
	$objDb->query($strQuery, false);
	$objDb->close();
}
 
 
//update pageviews
$strQuery = "
	INSERT INTO
		`".DB_PREFIX."stats_pageviews`
 
		(`pageview_ip`, `pageview_date`)
	VALUES
		('".$ip."', ".time().")
";
 
$objDb->query($strQuery, false);
$objDb->close();
?>