if i understand your question. why not take a different approach. when the
form is submitted do your updates/inserts and then forward the page with
the header() function to another page, even if it is the same page, but
with a different set of variables set on the page, the idea being to remove
the $_POST/$_GET arrays containing your data
so at the end of your insert
header("Location: ".$_SERVER['PHP_SELF']."?inserted=true");
you can send them from whence they came with
header("Location: ".$_SERVER['HTTP_REFERER']);
hth
jd
"Jeff"
<[EMAIL PROTECTED] To: [EMAIL PROTECTED]
> cc:
Subject: Re: [PHP-DB] MySQL Returns
Error
08/05/2003 06:41
PM
I'm unsure of both suggestions, can someone go into more detail?
"Richard Hutchins" <[EMAIL PROTECTED]> wrote in message
news:[EMAIL PROTECTED]
> So create a hidden input field on the page called cur_id and set its
value
> to the id of the record being displayed. If no record is currently being
> displayed, set it to -1.
>
> When you get ready to handle the form data, check the $_POST['cur_id']
> variable. If it's set to -1, perform an INSERT. If it's set to anything
> else, perform an UPDATE using the value of $_POST['cur_id'] in your WHERE
> clause.
>
> I'm sure there are other ways to handle this. This is how I have handled
it
> in the past though.
>
> > -----Original Message-----
> > From: Jeff [mailto:[EMAIL PROTECTED]
> > Sent: Tuesday, August 05, 2003 3:52 PM
> > To: [EMAIL PROTECTED]
> > Subject: Re: [PHP-DB] MySQL Returns Error
> >
> >
> > Oops, my mistake, it's not a blank entry - it re enters the
> > last entry.
> >
> > I can hit F5 or click refresh 1000 times and it will enter
> > the last entry
> > 1000 times.
> >
> >
> > "Jeff" <[EMAIL PROTECTED]> wrote in message
> > news:[EMAIL PROTECTED]
> > > I tried putting that in a few diffrent places, same result
> > - is there
> > > somewhere special I need to put that?
> > >
> > > "Matt Schroebel" <[EMAIL PROTECTED]> wrote in message
> > > news:[EMAIL PROTECTED]
> > >
> > >
> > > > -----Original Message-----
> > > > From: Jeff [mailto:[EMAIL PROTECTED]
> > > > Sent: Tuesday, August 05, 2003 3:15 PM
> > > > To: [EMAIL PROTECTED]
> > > > Subject: Re: [PHP-DB] MySQL Returns Error
> > > >
> > > > Every time I access or refresh the page, it adds one blank
> > > > entry to the DB.
> > > >
> > > > Maybe I have the insert query in the wrong place?
> > >
> > > if ('POST' == $_SERVER['REQUEST_METHOD']) {
> > > //someone submitted the form with method="post"
> > > // so validate input, and if okay store it in db
> > > }
> > >
> > >
> >
> >
> >
> > --
> > PHP Database Mailing List (http://www.php.net/)
> > To unsubscribe, visit: http://www.php.net/unsub.php
> >
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
