Timestamp field

[Myrkul]

I am writing a news script, and I want it to have a timestamp.. how can I have it detect this and enter it in the dbase as a field automatically?

[matt_4013]

In your SQL query, use the UNIX_TIMESTAMP and the NOW() function simultaneously.

For example:

INSERT INTO table (id, timestamp) VALUES ('', UNIX_TIMESTAMP(NOW()))

Hope that helps,
Matt

[Myrkul]

Also, how can I give each news post a numeric ID value, to distinguish it from the others?

[matt_4013]

Wait, I are you using a file, or a database?

[Myrkul]

a database

[matt_4013]

ok, that makes it easy then 🙂

When you create your table, you'll need an id field, give this field the "auto_number" attribute and make it the primary key.

That way, everytime you insert a record it will automatically give it a unique id, allowing you to keep them unique.

So for example, you wanted a news posting table, you would use this to create it:

CREATE TABLE `temp` (`id` INT UNSIGNED NOT NULL AUTO_INCREMENT, `username` VARCHAR( 255 ) NOT NULL ,
`timestamp` TIMESTAMP NOT NULL , `body` TEXT NOT NULL ,
PRIMARY KEY ( `id` ) );

[Myrkul]

ok back to the time thing

i have a hidden field with a value of:

<? echo time(); ?>

it echoes a timestamp.. how can i transform that into the following?

Monday, May 1 3:03 AM

[matt_4013]

Use the date function 🙂

http://www.php.net/date