I'm using the free tool "Phorm" to collect data from my form and try to send it to my DB.... anyway, here's the config file for Phorm that it uses to send the email and info to mySQL database:
<?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_ALERTTO = "caleb.shiffer@lebshiff.com"; // Change to your email address
$PHORM_TO = "caleb.shiffer@lebshiff.com"; // Change to your email address
$PHORM_SUBJECT = "Form Data"; // The subject of the email message
$PHORM_TMPL = ph_GENERIC; // A generic email template
$PHORM_ACK = "ack.htm"; // A generic ack template
$PHORM_MYDBV = "localhost, lebshif_lebshif, xxxxxxxx";
$PHORM_MYTABLE = "Tickets";
$PHORM_MYVARS = "email=email, AIM=AIM, bridge=bridge, ants=ants, nancies=nancies, Description=desc, TradeType=trade22, TradeType=trade21, TradeType=trade11, TradeType=trade12, Have=have%, Need=need%, Have=have, Need=need";
?>
Here's the form: http://www.lebshiff.com/trading.htm
I get an error message in the email that gets sent to me on each submit that it was "Unable to open Database variables file" -- would this be a fault of the php script or mySQL DB? I've also attached a screenshot of the DB....