Hello Everyone, I just wanted to drop in here and ask a couple questions of the PHP & SQL experts here. I've done work with the basics of SQL / PHP and ChronJob integration. However, I'm now on to trying to perform something a little more complex, and I'm banging my head a little bit on how exactly to get this done. In this I'm going to be using 2 tables, one we'll call Supply, another we'll call Distribution. A user (this is a browser based game), needs to elect to give X amount of supply to X member(s). The supply table contains the amount of supplies in each "Supply Depot". Basically using a ChronJob I need to do the following: 1: Select each individual Supply Depot, detect how much supply is requested (There is a column for the amount of supplies a location has, and a column for the level of supply they've requested to distribute), and then if the Supply Depot has enough supplies, release the supplies to the individual member(s). The problem I'm running into is that 1) there are multiple depots all distributing to different member(s), and 2) that the different depots may be releasing a different number of supplies. Tables/Columns In Use Table: Supply DepotColumns Within Table: TotalSupplies(int), SupplyLevel(varchar) <--- Supply level corrosponds to X amount of supplies per day, held elsewhere Table: MembersColumns Within Table: TotalSupplies(int), The index for both of these is a simple ID# column. The script will run once every 24 hours. My only guess on this was something along the lines of doing a different pull in the script for each supply level, something like: SELECT * FROM SupplyDepot WHERE SupplyLevel = 'Level1' Then some kind of For Each loop. But the exact method is elluding me, and I'm not sure if this is even the most effective method (I'm trying to do this with as little server load as possible because I expect traffic to be high. Thanks in advance guys!