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 '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)";
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
