Re: getting rows from separate tables stacked in a single array ? (newbie, mysql)

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$b18f0a18@aurora1.co.home.com>, fookilla@home.com ("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. >