Er det smart REPLACE INTO WHERE ipaddr
Hæ hæ har lavet lidt af noget fusk.. med at lave en SELECT id .. WHERE ipaddr .. sammen med REPLACE INTO :DEr det smart eller er det bare en omgang fusk.. det virker da fint nok.. :D
<?php
/*
CREATE TABLE `online` (
`id` int(11) unsigned NOT NULL auto_increment,
`dato` int(10) unsigned NOT NULL default '0',
`ipaddr` int(10) unsigned NOT NULL default '0',
`requist` varchar(150) character set latin1 collate latin1_bin NOT NULL default '',
`pagetitle` varchar(100) character set latin1 collate latin1_bin NOT NULL default '',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
*/
$strSQL = "REPLACE INTO online (id, dato, ipaddr, requist, pagetitle)
(SELECT (SELECT id FROM online WHERE ipaddr=INET_ATON('$_SERVER[REMOTE_ADDR]') LIMIT 1) AS id,
UNIX_TIMESTAMP() AS dato, INET_ATON('$_SERVER[REMOTE_ADDR]') AS ipaddr,
'$_SERVER[REQUEST_URI]' AS requist, '$title' AS pagetitle);";
mysql_query($strSQL, $sqlConn);
?>
