Hi,
I use this query to input data into MySQL DB.
EXPIRE is Expire Date!
My script allways inputs "1.1.0001" into database (as value of expire).
what is wrong?
My table:
CREATE TABLE korpa (
idnarudzbeukorpi int(255) DEFAULT '0' NOT NULL auto_increment,
mernaj varchar(255) NOT NULL,
nazivproizvoda varchar(255) NOT NULL,
ip_adresa_narucioca varchar(255) NOT NULL,
id_proizvoda varchar(255) NOT NULL,
kolicina_proizvoda decimal(255,2) DEFAULT '1.00' NOT NULL,
cena decimal(255,2),
datum datetime DEFAULT '0000-00-00 00:00:00' NOT NULL,
expire datetime,
PRIMARY KEY (idnarudzbeukorpi)
);
MySQL query:
$aSQL2="insert into korpa (mernaj, nazivproizvoda, ip_adresa_narucioca,
id_proizvoda, cena, datum, expire) values ('$mernaj', '$naziv', '$ip',
'$id', '$cena', now(), now()+3000)";
Please help me!
----------------------
----------------------
Djurovski Dejan
[EMAIL PROTECTED]
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
