]
Sent: Monday, December 30, 2002 7:15 PM
To: PHP List
Subject: [PHP] SQL Error
I'm having some troubles. I have an install script which runs a lot of
SQL statements to create tables then insert info into them. One of them
is an emoticons table. Here's the error I'm getting:
Y
I just tried this in MySQL and it inserted no problem
INSERT INTO c_emotes VALUES (6, ':-)');
Mike
*** REPLY SEPARATOR ***
On 30/12/2002 at 7:14 PM Stephen wrote:
I'm having some troubles. I have an install script which runs a lot of SQL statements
to create tables then i
I'm having some troubles. I have an install script which runs
a lot of SQL statements to create tables then insert info into them. One of them
is an emoticons table. Here's the error I'm getting:
You have an error in your SQL syntax near '; INSERT INTO c_emotes VALUES
\(':\)', 'emotes/smile
Original Message-
From: Jule Slootbeek [mailto:jslootbeek@;clarku.edu]
Sent: Wednesday, November 06, 2002 1:52 PM
To: Marco Tabini
Cc: [EMAIL PROTECTED]
Subject: Re: [PHP] sql error
apparently 'where' and 'with' are keywords in Java, i've changed them
and now it works
rchar(255) not null ...
---John Holmes...
-Original Message-
From: Jule Slootbeek [mailto:jslootbeek@;clarku.edu]
Sent: Tuesday, November 05, 2002 9:43 PM
To: Marco Tabini
Cc: [EMAIL PROTECTED]
Subject: Re: [PHP] sql error
Ah i see, but then why will phpMyAdmin let me use it?
it works fi
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
--
> Cc: [EMAIL PROTECTED]
> Subject: Re: [PHP] sql error
>
> 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/
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
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
"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 mail
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(
11 matches
Mail list logo