Diskuse

Téma: HCM & SQL

smety (4.12.2010 20:14)
Zdravim,
resim jeden problem se zapisem do mysql.
Zde je SQL:
CREATE TABLE IF NOT EXISTS `sunlight-spy` (
`id` int(11) NOT NULL auto_increment,
`nickid` text character set utf8 collate utf8_czech_ci NOT NULL,
`url` text character set utf8 collate utf8_czech_ci NOT NULL,
`time` text character set utf8 collate utf8_czech_ci NOT NULL,
`ip` text character set utf8 collate utf8_czech_ci NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
HCM:

if (_loginindicator==1){
$nickid = _loginid;
$url = _indexOutput_url;
$time = time();
$ip = $_SERVER["REMOTE_ADDR"];

mysql_query("INSERT INTO `"._mysql_prefix."-spy` VALUES (null,'".$nickid."','".$url."','".$time.",'".$ip."')");
}
zápise se ale neprovede, nevím proč :(
postZaslat odpověď
jval (6.12.2010 10:10)
Protože id je primary key a ty mu posíláš NULL, pošli mu '' a doplní se sám podle auto_incrementu a nebo mu neposílej vůbec nic:mysql_query("INSERT INTO `"._mysql_prefix."-spy` (nickid,url,time,ip) VALUES ('".$nickid."','".$url."','".$time.",'".$ip."')");