J!Extensions Store™
Forum
Welcome, Guest
Please Login to access forum.
- Joomla! Extensions Store
Re:Restricted list of users (1 viewing) 
Go to bottom
TOPIC: Re:Restricted list of users
#4310
John Dagelmore
Admin
Posts: 3881
User Online Now
Re:Restricted list of users Karma: 84  
Hello Bertrand,

yes the SQL query and the chat app is quite complex and is built on several criteria.

From your explananations i see that you need to add 2 more SQL JOINS and filter by user id.

This can be done directly in the bode of the final query concatenation.

Code:
$sql = "SELECT u.id, u.$userFieldName, sess.time ..... ORDER BY u.$userFieldName ASC";
Cheers, John
 
Logged Logged  
  The administrator has disabled public write access.
      Topics Author
    thread link
Restricted list of users
Digital Enterprise Engineering
    thread link
thread linkthread link Re:Restricted list of users
John Dagelmore
    thread link
thread linkthread linkthread link Re:Restricted list of users
Digital Enterprise Engineering
    thread link
thread linkthread linkthread linkthread link Re:Restricted list of users
John Dagelmore
    thread link
thread linkthread link Re:Restricted list of users
Digital Enterprise Engineering
    thread link
thread linkthread linkthread link Re:Restricted list of users
John Dagelmore
Go to top