Re: Form submit to Mysql database

Hello, maybe you don't initialise the cookie in the second page, so the third does not receive it. Anyway, I don't think the error is in the code section provided. There is nothing strange like this I have ever noticed in MySQL, always my code's fault. There was about a month ago an article on www.phpbuilder.com on multi-page forms. Something with $$$.. Read it and the comments. This may help you. The way I'd do it doesn't involve cookies. Good luck, -- Cordialement ------------------------------------------------------ Calin Uioreanu udmsromkt@mail.dntcj.ro DMS Team Cluj-Napoca Romania ----------------------------------------------------- ""Shannon Doyle"" <shannon@bigblue.net.au> wrote in message news:NEBBKKOHGLLAMDCMLMAFAEIGCGAA.shannon@bigblue.net.au... > > That is what I need it to do. Update the existing record with the value in > quote cookie. Every page contains further data for that record using > different field names. I am qondering why it is not updating the record > after the 2nd update has been done. ie. the first page inserts a record, the > second through to the 7th page updates this record changing values of > existing fields. However this is not functioning, after the second page the > fields are no longer being updated. > > I hope that clarifys my problem a little better :) > -Shannon > > > > This code "updates" only the records that have QuoteCookie='$QuoteCookie'. > If $QuoteCookie doesn't have its value changed the same record is updated > every time you submit the form. You are not inserting records, just > updating. No records will be added to your table. > > HTH > > Jayme. > > http://www.conex.com.br/jjeffman > > > > -----Mensagem Original----- > De: Shannon Doyle <shannon@bigblue.net.au> > Para: Php-Db@Lists. Php. Net <php-db@lists.php.net> > Enviada em: quarta-feira, 29 de novembro de 2000 22:33 > Assunto: [PHP-DB] Form submit to Mysql database > > > > 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@lists.php.net > > For additional commands, e-mail: php-db-help@lists.php.net > > To contact the list administrators, e-mail: php-list-admin@lists.php.net > > > > > -- > PHP Database Mailing List (http://www.php.net/) > To unsubscribe, e-mail: php-db-unsubscribe@lists.php.net > For additional commands, e-mail: php-db-help@lists.php.net > To contact the list administrators, e-mail: php-list-admin@lists.php.net > > > > -- > PHP Database Mailing List (http://www.php.net/) > To unsubscribe, e-mail: php-db-unsubscribe@lists.php.net > For additional commands, e-mail: php-db-help@lists.php.net > To contact the list administrators, e-mail: php-list-admin@lists.php.net >