Posting the Current Date

Anon

Hey this involves two pages. My first page has a form with just one field. The person given access to it types in whatever, hits submit, and it posts up one the second page. I want it so that when the person posts, the date and time is given. The date is fine but the time keeps being the maximum of 838:59:59.

Here is the code I am using in the form...

$today = date("y-m-d");
$timer = time("h,m,s");
$query = "insert into trash (talk, createDate, createTime) values (\"$queryi\",\"$today\", \"$timer\")";
$result = mysql_query($query);

It's basically just putting whatever into the database. I need it so that the time put in is the current time..... not that max number. Thx to anyone who can help!

Anon

er I mean posting the time sorry heh

Anon

The way I post time is as follows:

When I create a table, I create a column for date of type DATETIME. E.g.

create table trash (
posted DATETIME,
....

Whenever I want to post the current date, I just do:

insert into trash (posted) values(now())

The query will post the current date as yyyy-mm-dd hh:mm:ss

Whenever I read the date from the database (SELECT posted FROM trash), it comes out as 2002-12-21 16:08:49. But I usually want my date in the form:
Thu, 21 Dec 2002 16:08:49.

So, I format it as follows:

$i = explode(" ", $posted);
$j = explode(":", $i[1]);
$k = explode("-", $i[0]);
$posted = date("D, d M Y H:i:s", mktime($j[0],$j[1],$j[2],$k[1],$k[2],$k[0]));

echo "$posted";

Richie.
www.geocities.com/akindele/

Anon

Hey thx a lot! I was actually using variables call now I didn't know about the preset function :-)