[PHP-DB] Form submit to Mysql database From: Shannon Doyle (shannon <email protected>)
Date: 11/29/00

Hi people,
I am in the process of developing a multi page form for a client that is
wanting the resposes of the form to be implemented into a mysql database.
While I have the first section of the page entering the data into the
database I have discovered that after the first 2 submissions the database
is no longer being updated by my code. I have included a small section of
the code used to update the database in the hope that one of you on the list
may be able to help me discover why it is failing to update or perhaps
suggest a different way that I can insert this info into the database. The
database currenly has approx 200 fields that will need to be updated from 7
different forms.

<?
include("settings.php");
$iscookie=$QuoteCookie;
if ($iscookie == "") {
Header("Location: ./quotes.php");
}
mysql_connect("$dbhost","$dbuser","$dbpass");
mysql("richmitch","UPDATE quotes set
bar_lounge='$bar_lounge',
bar_family='$bar_family',
fridge_lounge='$fridge_lounge',
chair_lounge='$chair_lounge',
chair_family='$chair_family',
china_lounge='$china_lounge',
china_family='$china_family',
coffee_lounge='$coffee_lounge',
coffee_family='$coffee_family',
lounge_lounge='$lounge_lounge',
lounge_family='$lounge_family',
organ_lounge='$organ_lounge',
organ_family='$organ_family',
WHERE QuoteCookie='$QuoteCookie'");
?>

any help would be appreciated.

regards,
Shannon 

-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: php-db-unsubscribe <email protected>
For additional commands, e-mail: php-db-help <email protected>
To contact the list administrators, e-mail: php-list-admin <email protected>