Re: MySQL

Now that I look at it again I didn't see a parse error either, although I
think you could get away with the reserved word because I've used type as a
column name myself. I think you may have missed a ; on the line before.

Rossi Designs
PO Box 1084
Holly Hill, FL 32125-1084
Phone : (904) 226-8979
URL : http://rossidesigns.net
----- Original Message -----
From: Tom Grenier <tom(at)sqlman.com>
To: Sue Bailey <sue(at)bartandsue.co.uk>
Cc: <hwg-languages(at)hwg.org>
Sent: Sunday, May 14, 2000 4:49 PM
Subject: Re: MySQL


| Hi Sue,
|
| First let me say I don't know MySQL -- I'm an Oracle/Informix DBA -- so
| I may be way off base.  Your query looks fine to me -- with one possible
| exception.
|
| In Oracle PL/SQL type is a reserved word.  Both Oracle and Informix will
| allow you to use reserved words in table creation, then give you varying
| amounts of grief when trying to use them (which, IMHO, is pretty stupid).
| So, I'm wondering if you are using an MySQL or PHP reserved word
| (most likely type -- but I see another couple of candidates).
|
| Probably not much help -- but something to check.
|
| Tom
|
|
|
|
| Sue Bailey wrote:
|
| > Can anyone help me with writing to this wretched database?!
| >
| > I am getting a parse error with the following line:
| > mysql_query ("INSERT INTO foobah (item_number, designer, type, price,
rrp,
| > short_desc, long_desc, sizes, pic_one, pic_two, pic_three, weight)
| >                 VALUES ('$item_number', '$designer', '$type', '$price',
| > '$rrp', '$short_desc', '$long_desc', '$sizes', '$pic_one', '$pic_two',
| > '$pic_three', '$weight')
| >              ");
| > which is part of a PHP script just designed to take the input of the
form
| > and add it into foobah, my testing table. I don't see what's wrong with
it,
| > I'm at my wits end!! Can anyone make any suggestions?
| >
| > TIA
| >
| > Sue
|
|

HWG: hwg-languages mailing list archives, maintained by Webmasters @ IWA