[PHP] SQL datetime ERROR !
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 '-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
[PHP] SQL datetime ERROR !
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 '-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
Re: [PHP] SQL datetime ERROR !
Hi Djurovski, 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 '-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); Adding apples to oranges? expire is a datetime column. what format does now() produce its result in? can an integer (3,000) be added to that? =dn -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php