Seriously puzzling question...

Anon

Sorry about the blank post... damn enter key.

Anyways, I cannot figure out for my life why this won't work...

I'm trying to insert the time into mysql...

This is the code I'm using:

$post_hour = $expire_year . $expire_month . $expire_day . $post_hour . "0000";
$expire_hour = $expire_hour . ":00:00";

print "<br>" . $post_hour;
print "<br>" . $expire_hour;

/ create query /
if ($id == "") {
$query = "INSERT INTO $tbl_name
(ID, modify_date, post_date, post_time, expire_date, expire_time,
status, weight,
title, summary, content,
link_title, link_url, filepath, section_id
)
VALUES
(NULL, NOW(), '$post_date', '$post_hour', '$expire_date', '$post_hour',
'$status', '$weight',
'$title', '$summary', '$content',
'$link_title', '$link_url', '$filepath', '$section_id')
";
} else {

$query = "UPDATE $tbl_name SET
post_date = '$post_date',
expire_date = '$expire_date',
status = '$status',
weight = '$weight',
title = '$title',
summary = '$summary',
content = '$content',
link_title = '$link_title',
link_url = '$link_url',
filepath = '$filepath',
section_id = '$section_id'
WHERE ID = '$id'
";

}

Now, $post_hour; is coming out correctly (20011014240000) when I print it, but when I run an insert, nuttin! But I can insert into the database if I use $post_hour = date("Y-m-d G:i:s");

So, what the hell is the difference?! Why won't it insert??

Anyways, I sure could use some help. I'm sure it's something simple...

Thanks!

amcgrath

outta curiousity, is mysql_query($query,$connection) somewhere farther below this code? Another thing: is ID your primary key?

Anon

mysql_query($query,$connection)

Yea, sorry... It's right below what I posted. Do you want me to post it? Would that help?

Yes, ID is primary key.

amcgrath

Wel, if ID is you primary key and you are setting it as NULL in the SQL, that would mean you would only be allowed to enter one record before you get an data inegrity violation. Is the ID column a default sequencial value? If so let the database automatically insert the value when you run the insert query....

Anon

Curiously, it works:

+----+----------------+------------+----------------+-------------+----------------+--------+--------+------------+-------------------+---------------------+------------------------------------+------------+----------+----------+
| ID | modify_date | post_date | post_time | expire_date | expire_time | status | weight | section_id | title | summary | content | link_title | link_url | filepath |
+----+----------------+------------+----------------+-------------+----------------+--------+--------+------------+-------------------+---------------------+------------------------------------+------------+----------+----------+
| 2 | 20011015041940 | 2001-10-14 | 00000000000000 | 2001-10-19 | 00000000000000 | 1 | 2 | 0 | This is the title | This is the summary | And this, no doubt, is the content | | | |
| 3 | 20011015025614 | 2001-10-14 | 00000000000000 | 2001-10-14 | 00000000000000 | 2 | 2 | 0 | This is the title | This is the summary | And this, no doubt, is the content | | | |
| 4 | 20011015025936 | 2001-10-14 | 00000000000000 | 2001-10-14 | 00000000000000 | 2 | 2 | 0 | This is the title | This is the summary | And this, no doubt, is the content | | | |
| 5 | 20011015025959 | 2001-10-14 | 00000000000000 | 2001-10-14 | 00000000000000 | 2 | 2 | 0 | This is the title | This is the summary | And this, no doubt, is the content | | | |
| 6 | 20011015030247 | 2001-10-14 | 00000000000000 | 2001-10-14 | 00000000000000 | 2 | 2 | 0 | This is the title | This is the summary | And this, no doubt, is the content | | | |
| 8 | 20011015030351 | 2001-10-14 | 00000000000000 | 2001-10-14 | 00000000000000 | 2 | 2 | 0 | This is the title | This is the summary | And this, no doubt, is the content | | | |
| 9 | 20011015030550 | 2001-10-14 | 00000000000000 | 2001-10-14 | 00000000000000 | 2 | 2 | 0 | This is the title | This is the summary | And this, no doubt, is the content | | | |
| 10 | 20011015031451 | 2001-10-14 | 00000000000000 | 2001-10-14 | 00000000000000 | 2 | 2 | 0 | This is the title | This is the summary | And this, no doubt, is the content | | | |
| 11 | 20011015035252 | 2001-10-14 | 00000000000000 | 2001-10-14 | 00000000000000 | 2 | 2 | 0 | This is the title | This is the summary | And this, no doubt, is the content | | | |
| 12 | 20011015035300 | 2001-10-14 | 00000000000000 | 2001-10-14 | 00000000000000 | 2 | 2 | 0 | This is the title | This is the summary | And this, no doubt, is the content | | | |
| 13 | 20011015035323 | 2001-10-14 | 00000000000000 | 2001-10-14 | 00000000000000 | 2 | 2 | 0 | This is the title | This is the summary | And this, no doubt, is the content | | | |
+----+----------------+------------+----------------+-------------+----------------+--------+--------+------------+-------------------+---------------------+------------------------------------+------------+----------+----------+
11 rows in set (0.02 sec)

mysql>

I think what I'm going to do is to try to use datetime instead of timestamp, and change the formatting to something like:

$post_hour = "$expire_year-$expire_month-$expire_day $post_hour:00:00";

This was the suggestion I got from a friend. I'll let you know if it fixed the problem...

amcgrath

Curiously? Naw, that's (one of) the purpose to a primary key.

Anon

"Wel, if ID is you primary key and you are setting it as NULL in the SQL, that would mean you would only be allowed to enter one record before you get an data inegrity violation."

Allen, I don't understand. I was referring to your above statement, and would like to understand what you're getting at...

I did get it all working, btw. Thanks for the help!