Re: sql error

"where" is a reserved keyword in SQL--try changing the name of that column to something else. Marco ----------- php|architect -- The Monthly Magazine For PHP Professionals Visit us on the web at http://www.phparch.com! On Tue, 5 Nov 2002, Jule Slootbeek wrote: > I know this is the wrong mailinglist, but i don't want to subscribe to > a second one for one random question. > > when trying to enter this into my db: > > DROP TABLE IF EXISTS dates; > CREATE TABLE dates ( > id int(10) unsigned NOT NULL auto_increment, > date varchar(50) NOT NULL default '', > at varchar(50) NOT NULL default '', > where varchar(255) NOT NULL default '', > with varchar(255) NOT NULL default '', > whereURL varchar(100) NOT NULL default '', > info varchar(255) NOT NULL default '', > PRIMARY KEY (id) > ) TYPE=MyISAM; > > (this is generated by phpMyAdmin) > > i get this error: > > ERROR 1064 at line 18: You have an error in your SQL syntax near 'where > varchar(255) NOT NULL default '', > with varchar(255) NOT NULL default '',' at line 5 > > where's the error? > i don't see anything wrong.. > > TIA, > > Jule > > Jule Slootbeek > jslootbeek@clarku.edu > > >