I did put a spot ID because I never thought of building a temp table on
the fly and dropping it at the end of the script. :-) Now that is an
elegant concept !
I was going for a permanent table, wich would have been heavier to feed
when other tables got updated (but wich would have been automated). The
spot_id was the key to select the items. Making it a temp table is even
simpler.
Altho on second though it means I have to grant create/write/drop
privileges to the clients, wich might open security issues... mmmhh.
I must say, this newsgroup rocks. I recieved highly valuable input on this
thread and by email.
Thank you all !
Nicolas
In article <002b01c0cd39$3f86c240$[EMAIL PROTECTED]>,
[EMAIL PROTECTED] ("Steve Lawson") wrote:
> Doh, I shoulda thought of that, a temp table is the best way to do it.
> Altho, I don't see why you have a spot_id as a key for that table. Your are
> probably never going to access that table via that arbitrary number. If
> anything, you should make item_id the key. The id on your other tables
> should also be keys.
>
> SL.
>
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
