Re: MySQL

Thanks for all the advice guys. Turns out the problem was indeed a missing ;
on the previous line-- duh!

Sue

----- Original Message -----
From: Rossi Designs <webmaster(at)rossidesigns.net>
To: Tom Grenier <tom(at)sqlman.com>; Sue Bailey <sue(at)bartandsue.co.uk>
Cc: <hwg-languages(at)hwg.org>
Sent: Monday, May 15, 2000 12:03 AM
Subject: 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