Create a field in your table called something like 'date' and make its data type TIMESTAMP. MySQL will automatically add a timestamp with each new entry ... assuming you're using UNIX, I don't know about windows. Mick > I know this has been brought up repeatedly but I couldn't find the archives website. > I'm doing a news publishing script (something like newsphp \ php-nuke) but uses >mySQL to store all the data instead of flat files. > I would like to make it such that everytime I submit an news entry, the time\date >will automatically be inserted in that row. > Could someone give me some suggestions? -- PHP General Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]