Re: Update identical table
| From: | Justin French | Date: | Sun, 29 Sep 2002 23:59:07 +0000 |
| Subject: | Re: Update identical table | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-118132@lists.php.net to get a copy of this message | ||
on 30/09/02 8:09 AM, David Freeman (dfreeman@outbackqld.net.au) wrote:
> 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).
totally agree
Justin