Re: [PHP-DB] Form submit to Mysql database From: Uioreanu Calin (uioreanu <email protected>)
Date: 11/30/00

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 <email protected>
DMS Team Cluj-Napoca Romania
-----------------------------------------------------
""Shannon Doyle"" <shannon <email protected>> wrote in message
news:NEBBKKOHGLLAMDCMLMAFAEIGCGAA.shannon <email protected>
>
> 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 <email protected>>
> Para: Php-Db <email protected> Php. Net <php-db <email protected>>
> 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 <email protected>
> > For additional commands, e-mail: php-db-help <email protected>
> > To contact the list administrators, e-mail: php-list-admin <email protected>
> >
>
>
> --
> 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>
>
>
>
> --
> 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>
>

-- 
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>