RE: [PHP-DB] MySQL Returns Error

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: [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" <jroth1@telus.net> wrote in message > 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 > > > > 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: [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 >