View Single Post
  #11  
Old 31st October 2008, 19:01
quentusrex quentusrex is offline
Senior Member
 
Join Date: May 2008
Posts: 174
Thanks: 6
Thanked 11 Times in 7 Posts
Default

The SQL statement:

"SELECT client.client_id FROM sys_group, client WHERE sys_group.client_id = client.client_id and sys_group.groupid = 1"

returns 0 rows, no matter how many clients I have in the database. It seems that:

SELECT client.client_id FROM sys_group, client WHERE sys_group.groupid = 1

returns all of the clients. So the statement needs to be something like:


"SELECT client.client_id FROM sys_group, client WHERE sys_group.client_id = $????client_id and sys_group.groupid = $client_group_id"
Reply With Quote
Sponsored Links