RE: [PHP] Why would this command just Die!
| From: | David Freeman | Date: | Sun, 19 May 2002 23:07:05 +0000 |
| Subject: | RE: [PHP] Why would this command just Die! | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-98394@lists.php.net to get a copy of this message | ||
> INSERT INTO prizeline (id, email, name, address, answers,
> date) VALUES ('', 'newmanpj@philipsdomain.com', '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