Re: problem bug

Year is a reserved word in mysql as far as I can remember, so rename your column. BTW this email address is not the appropriate forum for asking support questions. For a list of more appropriate places to ask for help using PHP, please visit http://php.net/support Thank you for your interest in PHP. Goba [one webmaster@php.net] ----- Original Message ----- From: "Carli Wessels" <carliwessels@hotmail.com> To: <webmaster@php.net> Sent: Wednesday, October 30, 2002 11:56 AM Subject: problem bug > tried everything but couldn´t find the solution, it´s all about the bug with > 4.2.3 and apache and phpmyadmin, like a simple query: > > $query = "CREATE TABLE events ( > eventID INTEGER AUTO_INCREMENT PRIMARY KEY, > year INTEGER, > month INTEGER, > day INTEGER, > title VARCHAR(255), > event TEXT)"; > > # Error creating table > You have an error in your SQL syntax near 'events ( eventID INTEGER > AUTO_INCREMENT PRIMARY KEY, year ' at line 1End of setup > > and it seems to like its a bug for me, because else it's working, so could > you mail the solution as soon as possible, bacause it critical for my firm. > :) thanks > > Carli > > _________________________________________________________________ > Wil je je beveiligen tegen Ongewenste Post? Klik hier voor tips > http://www.msn.nl/services/hotmail/ongewenst/ > >