Form submit to Mysql database

From: Date: Thu, 30 Nov 2000 00:33:01 +0000
Subject: Form submit to Mysql database
Groups: php.db 
Request: Send a blank email to php-db+get-4857@lists.php.net to get a copy of this message
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

« previous php.db (#4857) next »