Re: how to clear variabeles

I use SyBase, and could not find REPLACE INTO in my manuals. Is it MySQL (or some other DB)-specific? Carroll Barrett -----Original Message----- From: Daevid Vincent <DayWalker@TheMatrix.com> To: php-db@lists.php.net <php-db@lists.php.net> Cc: Eelco de Graaff <eelco@tri-angle.demon.nl> Date: Tuesday, June 27, 2000 4:24 PM Subject: RE: [PHP-DB] how to clear variabeles >you could also just manually go through and set the variables to "" after >you insert them into the db... >then the form is blank and a duplicate post would 'error' and you can check >for that. > >the only problems so far are some idiot user using the 'back button' on >their browser. the only way to get around that, that I know of is to check >the db to see if that record exists before inserting... there is a "REPLACE >INTO" SQL statement that works like a combo of INSERT and UPDATE, it >"inserts data into a table, replacing any old data that conflicts" that may >be of help. > >> -----Original Message----- >> From: Eelco de Graaff [mailto:eelco@tri-angle.demon.nl] >> Sent: Tuesday, June 27, 2000 8:47 AM >> To: php-db@lists.php.net >> Subject: [PHP-DB] how to clear variabeles >> >> >> Hi, i have created a php based form, data is posted to the mysql >> database. I >> have found that it is possible to do 2 postings to the database with the >> same data. Is there a function or a way to clear al the >> variabeles after the >> mysql_query function to make shure data is not duplicated posted? >> >> >> >> -- >> 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 >