[PHP] SQL datetime ERROR !

2002-08-13 Thread Djurovski Dejan

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 !

2002-08-13 Thread Djurovski Dejan

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 !

2002-08-13 Thread DL Neil

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