PDA

View Full Version : editing a query


Mazinger
09-14-2008, 07:57 PM
From this mod: https://vborg.vbsupport.ru/showthread.php?p=880271#post880271

That query:

SELECT * FROM vb3_forumpermission
WHERE ( forumid IN() AND usergroupid IN (1)) AND
(maxthread=0 AND perhour=0);
I want to apply this query on multipe usergroups and multipe forums (array) then re-format this query.

Any help will be appreciated. :)

Dismounted
09-15-2008, 05:42 AM
Just implode() your array and use a comma as the separator. Then put it in the query...

Mazinger
09-15-2008, 06:30 PM
Yes, I know that should happen but can't do it.

Can you reformat my query with your instructions? please.

Dismounted
09-16-2008, 05:51 AM
You need to change the PHP code around and including it.