Re: sql error

did I say Java? oops, i meant SQL....learning Java in my comp sci class..(= forgive me. Jule On Tuesday, Nov 5, 2002, at 21:54 US/Eastern, Martin Towell wrote:

"where" is a java keyword ? have you got an example ? It's been _ages_ since I've done any code in java :( -----Original Message----- From: Jule Slootbeek [mailto:jslootbeek@clarku.edu] Sent: Wednesday, November 06, 2002 1:52 PM To: Marco Tabini Cc: php-general@lists.php.net Subject: Re: [PHP] sql error apparently 'where' and 'with' are keywords in Java, i've changed them and now it works fine. thanks! Jule On Tuesday, Nov 5, 2002, at 21:53 US/Eastern, Marco Tabini wrote:

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

Jule Slootbeek jslootbeek@clarku.edu -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php Jule Slootbeek

jslootbeek@clarku.edu