New Posts New Posts RSS Feed - lastest topics (creator of topics)
  FAQ FAQ  Forum Search   Register Register  Login Login

lastest topics (creator of topics)

 Post Reply Post Reply Page  <123
Author
Matt View Drop Down
Admin Group
Admin Group


Joined: 07 Feb 2003
Location: Manchester, UK
Status: Offline
Points: 195
Post Options Post Options   Quote Matt Quote  Post ReplyReply Direct Link To This Post Posted: 27 Aug 2010 at 12:33pm
take out the ' strSQL = strSQL & ' part of the red section, it shouldnt be there
Back to Top
macpack View Drop Down
Newbie
Newbie


Joined: 19 Jun 2009
Status: Offline
Points: 38
Post Options Post Options   Quote macpack Quote  Post ReplyReply Direct Link To This Post Posted: 27 Aug 2010 at 3:35pm
Perfect now it works mate... Thanks you very very much for the big help you always give me, and thanks for the time..
Back to Top
macpack View Drop Down
Newbie
Newbie


Joined: 19 Jun 2009
Status: Offline
Points: 38
Post Options Post Options   Quote macpack Quote  Post ReplyReply Direct Link To This Post Posted: 13 Sep 2010 at 10:39pm

Hey again scotty,

How can i show exempel 4 cats in this script.?


Now it only shows 1 forum cat if i change it to:
  "AND " & strDbTable & "Forum.Cat_ID = 3 " & _


But how can i change it, so i can show 4 different Forum Cats.?

Regards
André

Back to Top
Matt View Drop Down
Admin Group
Admin Group


Joined: 07 Feb 2003
Location: Manchester, UK
Status: Offline
Points: 195
Post Options Post Options   Quote Matt Quote  Post ReplyReply Direct Link To This Post Posted: 13 Sep 2010 at 11:15pm
If you want to show from more than one category it would be:

"AND (" & strDbTable & "Forum.Cat_ID = 1 OR " & strDbTable & "Forum.Cat_ID = 2 OR " & strDbTable & "Forum.Cat_ID = 3 OR " & strDbTable & "Forum.Cat_ID = 3) " & _


Obviously changing the ID numbers to the ones you want.
Back to Top
macpack View Drop Down
Newbie
Newbie


Joined: 19 Jun 2009
Status: Offline
Points: 38
Post Options Post Options   Quote macpack Quote  Post ReplyReply Direct Link To This Post Posted: 13 Sep 2010 at 11:21pm
thank you very very much my friend.
Back to Top
 Post Reply Post Reply Page  <123
  Share Topic   

Forum Jump Forum Permissions View Drop Down



This page was generated in 0.094 seconds.