Re: Timestamp allways zero zero

2001-11-14 Thread Chris Cooper
See below. On Wed, 2001-11-14 at 14:40, Jason Wong wrote: > The above can be re-written as: > > //En record for hvert navnedomene > $sql = "CREATE TABLE domains ( > dNbr INTEGER UNSIGNED AUTO_INCREMENT NOT NULL PRIMARY KEY, > dName CHAR(25) NOT NULL, > payP

Re: Timestamp allways zero zero

2001-11-14 Thread Gerald Clark
The whole point of a time stamp is that you do NOT insert its value. Leave it out. Olav Drageset wrote: > Professionals! > I cannot get timestamp to contain a time value different from zero. > According to another mailing this shall happen when something is done wrong > I am completely new to da

Re: Timestamp allways zero zero

2001-11-14 Thread Carl Troein
Olav Drageset writes: > I cannot get timestamp to contain a time value different from zero. > $tid = "NOW(YY-MM-DD HH:MM:SS)"; > $sql .= "VALUES ('$domainName', '$payPerYear', '$nxtPayDay', '$tid', You're trying to INSERT the string constant 'NOW(YY-MM-DD HH:MM:SS)' which will be converted int

Re: Timestamp allways zero zero

2001-11-14 Thread Jason Wong
On Thursday 15 November 2001 01:38, Olav Drageset wrote: > Professionals! > I cannot get timestamp to contain a time value different from zero. > According to another mailing this shall happen when something is done > wrong I am completely new to databases. I am initiating the database > tables f

Timestamp allways zero zero

2001-11-14 Thread Olav Drageset
Professionals! I cannot get timestamp to contain a time value different from zero. According to another mailing this shall happen when something is done wrong I am completely new to databases. I am initiating the database tables from a php page. Can anyone tel me what I am doing wrong?? Thank you