I'm have 2 tables as follow my users table and my online_users table.
I want to show on my pages my online users first and under this the offline users. So i work with a LEFT JOIN to select my online users first but i don't know how i can first show my online users random. If i do order by rand() then it doesn't show the online first but the whole members table random.
I work also via a navigation with 100 users per page.
users LEFT JOIN online_users ON ...
selects all users, if there is no matching record in online_users those fields are considered NULL and that you can use for ORDER BY.