hey guy,
right now I ma trying to build something like forum and I have a problem in there.
Alright, say I have 3 tables in mysql db. One for users, one for topics, and one for replies. When I submit info my php script check for username and pass and then adds info into tables. My 'topic' table has theses parameters in it:
'id' 'author' 'topics' 'repnum' 'modtime'
so the question is, how do I add current time into that last one column 'modtime'. I tried to make it 'DATETIME' but it showed only 0's. Yet if I do it manually from command line in works fine.
Another question, is my structure for forum anywhere close to what other people use? I just made it up and not quite sure is that the way to do it
thanks for you help,
cheers
right now I ma trying to build something like forum and I have a problem in there.
Alright, say I have 3 tables in mysql db. One for users, one for topics, and one for replies. When I submit info my php script check for username and pass and then adds info into tables. My 'topic' table has theses parameters in it:
'id' 'author' 'topics' 'repnum' 'modtime'
so the question is, how do I add current time into that last one column 'modtime'. I tried to make it 'DATETIME' but it showed only 0's. Yet if I do it manually from command line in works fine.
Another question, is my structure for forum anywhere close to what other people use? I just made it up and not quite sure is that the way to do it
thanks for you help,
cheers