|
|
|
|
Joined: Apr 2001
Posts: 186
Member
|
|
Member
Joined: Apr 2001
Posts: 186 |
i made a list of all members off one group, and i worked well, but all them who was in several groups didnt show ??
U_Groups LIKE '%-5-%'
how do i do so that i see all members off one group ??
Thomas
|
|
|
|
|
Joined: Mar 2003
Posts: 215
Junior Member
|
|
Junior Member
Joined: Mar 2003
Posts: 215 |
Show U_Groups in the results to see what it is matching?
|
|
|
|
|
Joined: Apr 2001
Posts: 186
Member
|
|
Member
Joined: Apr 2001
Posts: 186 |
in the database, a user looks like this if he has more than one group
'-6-12-'
isnt i possible to make the php script only find the -6- and not the -12-
Thomas
|
|
|
|
|
Joined: Nov 2001
Posts: 10,369
I type Like navaho
|
|
I type Like navaho
Joined: Nov 2001
Posts: 10,369 |
WHERE U_Groups LIKE '%-5-%' AND NOT LIKE '%-12-%' I think that would work - untested though. 
|
|
|
Donate to UBBDev today to help aid in Operational, Server and Script Maintenance, and Development costs.
Please also see our parent organization VNC Web Services if you're in the need of a new UBB.threads Install or Upgrade, Site/Server Migrations, or Security and Coding Services.
|
|
|
Posts: 417
Joined: November 2001
|
|
|
Forums63
Topics37,575
Posts293,930
Members13,823
| |
Most Online6,139
Sep 21st, 2024
|
|
Currently Online
Topics Created
Posts Made
Users Online
Birthdays
|
|
|
|
|
|
