> I have 2 identical tables called "tmp_data" and "data". (on > the same mysql database). > What would be the simple and more convenient way to update > table "data" with a row from table "tmp_data".
What about getting rid of "tmp_data" completely and adding an extra column to your "data" table. The extra column, say "approved" would act as a flag that, if set (ie. "= 1") means that the data is confirmed and, if not set, means the data is not confirmed. Using this, you could use the setting in your "approved" column in queries to find data that you've not yet confirmed or whatever. Saves the whole mess of reading in data from one table to write to another table and also avoids the potential for errors if you change your database structure at all (and forget to make the change in both tables). CYA, Dave -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php