Posted 04 August 2006 - 05:37 AM
Posted 04 August 2006 - 06:08 AM
I had to
alter table stats add timestamp timestamp;
then when I added data from a script I put null into the timestamp field
echo "insert into stats values ( $input4 , $input5 , $input6 , $input13 , $input14 , $input15 , $input16,null );"
the $input#'s are just some script variables I added to the table.
Posted 04 August 2006 - 04:49 PM
BTW can you give an example of a column list and why is it preferrable?
Posted 04 August 2006 - 05:17 PM
Anyways, I swapped to the column list where I list the column names then the data that goes in em
insert into stats (cola,colb) values($input3,$input4);
It made it much easier to see what was exactly causing the error.
Thanks for the help
0 user(s) are reading this topic
0 members, 0 guests, 0 anonymous users