[SOLVED] Order a list with a Query result

Thank you Kyle.

I have tried differents codes... I think, I need something like this:


((SELECT `status` FROM `mrczi_vw_sessions` WHERE `user_id` = '[user_id]') IS NULL)

... but still it shows all cams (on and off)

Can you help me with the sintax?

I assume status of 1 means on? 0 is off? I suggest the below.

ON:
OFF:
You don't want to use substitutions as you don't want the query changed based off the viewing user, but instead based off the user rows returned. This causes the user row which is ue. (their _comprofiler row) to be checked against.

Community Builder is amazing!. Everyday we can discover something new.

Thank you for the help, Kyle.