Welcome to WebmasterWorld Guest from 22.214.171.124
Basically I will have 12 columns to update, each column a different item, each item a different level. if any of these levels are higher than that of the person updating then I do not want it passed.
if Jim is level 5 and has 3 items at level 3 and 2 at 6 he can only equip 3 items.
you can use arrays for a lot of stuff and i guess you can use it "even" for your problem but i do not understand it fully.
you can implement the security within the php code and verify the input and the userlevel. so if you define a level for each column and compare that columnlevel to the userlevel then you should be fine to go. using an array here might help you to store and access the level for each column in an easy way. i.e. [tt]$columnlevel = 3;[/tt] could set the level for column 0. with a foreach [php.net]you can then walk through all columns and compare it to the userlevel and eventually apply the update-value to your query if it's ok. finally a query is created with all the columns which are allowed only.
you thought about something like that?