on 30/09/02 8:09 AM, David Freeman ([EMAIL PROTECTED]) 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 -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
