right, may have found the problem with the mysql error.
if I try and add the query i posted before into the blank paypal_funds table it goes in fine. But, if I change the id to something else but it still starts with a 0 then I get the following error:
Code:
Error
SQL-query :
INSERT INTO paypal_funds( id, date, donated )
VALUES (
'0E567297NG154303X', NOW( ) , '4.63'
)
MySQL said:
Duplicate entry '0' for key 1
Now when i go back and look at the data in the table I see:
id date donated
0 2003-07-04 4.63
id is only a single figure, not that long one its trying to put in. Does this give you any pointers as to where the problem may lie?