Thanks James. I'll give that a shot.
From: php-list@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of James Keeline Sent: Thursday, July 03, 2008 1:58 PM To: php-list@yahoogroups.com Subject: Re: [php-list] need help adding/updating records --- Jim MacDiarmid <[EMAIL PROTECTED] <mailto:jim.macdiarmid%40comcast.net> > wrote: > I'm looking for the best way to code this. I'm having a brain bubble today. > Here is the scenario: I have a list of records with 2 buttons in the last > column for edit and delete. The "userid" is passed as a parameter with the > click of these buttons. When I click edit, it brings up a form with some > pre-populated data with exception to 1 description field. The query behind > this form is joining with 2 tables. Lets say one table is the User data > table and the other is a custom table with userid, and user description. > When I click the submit button on this edit form, it should do an > insert/update on this custom table. My question is to I need to make sure > the user id I want to edit exists in this table, or will an update query add > the record if it doesn't exist? If I may also ask, what would be the best > way to code this? If my situation is not clear, please feel free to let me > know and I'll try to explain more. An UPDATE query would fail if the record with the primary key does not exist. A REPLACE query is probably more helpful here. It's syntax is like INSERT. If you have any timestamp fields, they will be updated with either type of change. James [Non-text portions of this message have been removed]
