> INSERT INTO prizeline (id, email, name, address, answers,
> date) VALUES ('', '[EMAIL PROTECTED]', 'newman',
> '12 Newman ave Auckland', 'In Season, James, John', 'Monday
> 20th of May 2002 10:22:05 AM')There has been an error
If you want 'id' to be assigned by the database (I'm assuming you have
an auto_increment on that field) then don't put it in your insert at
all. The database will figure it out. As it is you're trying to assing
the id to '' (or nothing) which may well be why you're getting the
error.
(and this relates to php in what way? Perhaps an sql mailing list would
have been a more appropriate place...)
CYA, Dave
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
