[phorm] Trouble writing to MySQL Database "090 - Error on Query"
- From: "Paul Sullivan" <paul.sullivan14@xxxxxxxxxxx>
- To: <phorm@xxxxxxxxxxxxx>
- Date: Tue, 11 Mar 2003 20:31:01 -0500
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.
Other related posts:
