coloring cells

[tito]

Hello, what would be the best approach to handle this:

I got a table with many cells. Each cell represents a PC. Depending the state of the PC, connected, not connected and user location. I am able to create the user location code with the ip number placing the php code in every cell (if IP ==xxx.xxx.xx.x background=location.gif else background=other.gif etc...)

The other 2 states on or off, requires a connection to mysql. It occurs to me that if I were to make that mysql query for each cell, that will be a big load on server for 100 queries or more every time the page is loaded.

Please any suggestions on how to achieve this?

[greg252]

You do 1 query and loop through the results.(I assume that the PC col is in the DB as well. If not, why not?)
Within the loop, use a conditional to determine the state and display the color of choice.

[tito]

no it's not in the db. I do not know how.