[phorm] Re: Trouble writing to MySQL Database "090 - Error on Query"
- From: Phorm Support <support@xxxxxxxxx>
- To: Paul Sullivan <phorm@xxxxxxxxxxxxx>
- Date: Tue, 11 Mar 2003 23:00:20 -0500
'desc' is a MySQL reserved word and cannot be used as the name of a
database column.
--
Alan Little
Phorm Support
http://www.phorm.com/
On Tuesday, March 11, 2003, 8:31:01 PM, you wrote:
> I'm new to using Phorm and MySQL together...
> When I submit a form that tries to write to a MySQL table, I get the error:
> Internal Alerts:
> 090 - Error on query:
> insert into dev
> (firstname,lastname,email,phone,company,referred,prodname,version,desc,agree
> ) values ('p','p','p','p','p','p','p','p','p','on')
> MySQL says: You have an error in your SQL syntax near 'desc,agree values
> 'p','p','p','p','p','p','p','p','p','on'' at line 1
> I am using PHP version 4.3.1.
> I am defining all variables in a configuration file for the form, I am NOT
> using a sepreate $PHORM_MYDBV file. My config file looks like:
> <?php
> # This is the global configuration file. It's read every time Phorm runs.
> # If the form calling Phorm has a local (form-specific) configuration file,
> # settings in it will override settings here.
> # This variable indicates that a local config file is NOT required.
> $PHORM_RCONFIG = "N";
> $PHORM_QUOTES = True;
> $PHORM_ALERTTO = "paul.sullivan14@xxxxxxxxxxx"; // Change to your email
> address
> $PHORM_TO = "paul.sullivan14@xxxxxxxxxxx"; // Change to your email
> address
> $PHORM_SUBJECT = "Dev Form Data"; // The subject of the email
> message
> $PHORM_TMPL = ph_GENERIC; // A generic email template
> $PHORM_ACK = "devack.html"; // A generic ack template
> $PHORM_MYTABLE = "dev"; // The name of the table to
> log
> the form contents in.
> $PHORM_MYVARS = "firstname=firstname, lastname=lastname, email=email,
> phone=phone, company=company, referred=referred, prodname=prodname,
> version=version, desc=desc, agree=agree"; // A string containing the
> variables to log to the MySQL database.
> $DHost = "localhost";
> $DUser = "login";
> $DPass = "pass";
> $DBase = "dbase";
?>>
> I have actually set $DHost to "localhost". My ISP says that is the host
> name. Could that be a problem?
> I set $PHORM_QUOTES="True" in the phormconfig.php3 file.
> Other info that was returned to me:
> Phorm Variables:
> PHORM_RCONFIG: N
> PHORM_ALERTTO: paul.sullivan14@xxxxxxxxxxx
> PHORM_TO: paul.sullivan14@xxxxxxxxxxx
> PHORM_SUBJECT: Dev Form Data
> PHORM_TMPL: ::generic::
> PHORM_ACK: ./devack.html
> PHORM_QUOTES: 1
> PHORM_REGEX: 0
> PHORM_CONFIG: config_dev.php3
> PHORM_MYTABLE: dev
> PHORM_MYVARS: firstname=firstname, lastname=lastname, email=email,
> phone=phone, company=company, referred=referred, prodname=prodname,
> version=version, desc=desc, agree=agree
> PHORM_NAME:
> PHORM_LINEBRK:
> PHORM_LOG: Array
> PHORM_LOGVAR: Array
> PHORM_LDELIM:
> PHORM_LOGQUOT: '
> PHORM_MYSQLID: 0
> PHORM_FROM: paul.sullivan14@xxxxxxxxxxx
> PHORM_VARREG:
> PHORM_HEADERS:
> Form Data:
> PHORM_CONFIG: config_dev.php3
> firstname: p
> lastname: p
> email: p
> phone: p
> company: p
> url: p
> referred: p
> prodname: p
> version: p
> desc: p
> agree: on
> -------------------------------------------------
> You are receiving this message because you are subscribed to the Phorm
> mailing list. To send messages to the mailing list, simply send email to
> phorm@xxxxxxxxxxxxx from the address you have
> subscribed. You may unsubscribe from the list by sending email to
> phorm-request@xxxxxxxxxxxxx with 'unsubscribe' in the SUBJECT field.
-------------------------------------------------
You are receiving this message because you are subscribed to the Phorm mailing
list. To send messages to the mailing list, simply send email to
phorm@xxxxxxxxxxxxx from the address you have subscribed. You may unsubscribe
from the list by sending email to phorm-request@xxxxxxxxxxxxx with
'unsubscribe' in the SUBJECT field.
Other related posts:
