So my problem here is that:
I cannot insert into my auto incremented column from my php
(unless I set the insert values to: '','','','$postdate','posttime').
HOWEVER: When I used the DEBUGGED insert statement below in phpmyadmin, it ran no worries. Therefore there is something preventing my insertion from my php code.
This is my code:
$qinsert = "INSERT INTO `post` (text,sender,text_stamp,post_date,post_time) VALUES ('$message','$sender_id','$date','$postdate','$posttime')";
$finsert = mysql_query($qinsert);
$postID = mysql_insert_id();
This is the output from a debugger:
Date: Fri, 29 Mar 2013 11:02:53 -0400
Sender: User's Name
Message:
Message Text
Attachment:
Post-Date: 2013-03-29
Post-Time: 08:02:55
Q-INSRT: INSERT INTO `post` (text,sender,text_stamp,post_date,post_time) VALUES ('Message Text','User's Name ','Fri, 29 Mar 2013 11:02:53 -0400','2013-03-29','08:02:55')
F-INST:
Post-ID: