I'm unsure of both suggestions, can someone go into more detail? "Richard Hutchins" <Richard.Hutchins@Getingeusa.com> wrote in message 1EA7D3AE70ACD511BE6D006097A78C1E033C91A4@USROCEXC">news:1EA7D3AE70ACD511BE6D006097A78C1E033C91A4@USROCEXC... > 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:jroth1@telus.net] > > Sent: Tuesday, August 05, 2003 3:52 PM > > To: php-db@lists.php.net > > Subject: Re: 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" <jroth1@telus.net> wrote in message > > 20030805193545.88580.qmail@pb1.pair.com">news:20030805193545.88580.qmail@pb1.pair.com... > > > I tried putting that in a few diffrent places, same result > > - is there > > > somewhere special I need to put that? > > > > > > "Matt Schroebel" <MSchroebel@hsus.org> wrote in message > > > D4DB668A680B2549AE977FB0B193E2E80144F3B4@email.hsus.org">news:D4DB668A680B2549AE977FB0B193E2E80144F3B4@email.hsus.org... > > > > > > > > > > -----Original Message----- > > > > From: Jeff [mailto:jroth1@telus.net] > > > > Sent: Tuesday, August 05, 2003 3:15 PM > > > > To: php-db@lists.php.net > > > > Subject: Re: 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
