Re: sql error

I'm not entirely sure... different configurations perhaps? Have you verified that that's indeed the problem? 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: > Ah i see, but then why will phpMyAdmin let me use it? > it works fine on my local db with these names, but on my remote server > it refuses to create the table. > > Jule > > On Tuesday, Nov 5, 2002, at 21:47 US/Eastern, Marco Tabini wrote: > > > "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 > >> > >> > >> > > > > > Jule Slootbeek > jslootbeek@clarku.edu > > >