The Arcive of Official vBulletin Modifications Site.It is not a VB3 engine, just a parsed copy! |
|
|
#1
|
||||
|
||||
SQL Query for blogs question
I'm trying to query the sql database to only retrieve blogs that match a certain category but I can't figure out what the syntax is for categories.
I'm modifying an existing query that looks like this: PHP Code:
--------------- Added [DATE]1295136492[/DATE] at [TIME]1295136492[/TIME] --------------- Nevermind, I figured it out. For anyone who's interested, it's blog.categories, which I could've sworn I had tried before but I guess not. Also, you have to input the category ID, not the actual name of the category (string). So it looks like this: blog.categories='10' instead of blog.categories='Project Fanboy Columns' |
Thread Tools | |
Display Modes | |
|
|
X vBulletin 3.8.12 by vBS Debug Information | |
---|---|
|
|
More Information | |
Template Usage:
Phrase Groups Available:
|
Included Files:
Hooks Called:
|