The Arcive of vBulletin Modifications Site.

A Question for a Hacker · **Released**: 10-23-2003

Hello,

How do I tell the following sql query to grab from all forums? Or set
$forums to all?

$limit=10 ;
$forums= 19 ;

$sql = "SELECT threadid, title, forumid, replycount, postusername, postuserid, lastposter, dateline, FROM thread WHERE forumid = \"$forums\" ORDER BY threadid DESC LIMIT $limit";

Brad · #2 10-23-2003, 01:31 AM

Quote:

Originally Posted by Hooper

Hello,

How do I tell the following sql query to grab from all forums? Or set
$forums to all?

$limit=10 ;
$forums= 19 ;

$sql = "SELECT threadid, title, forumid, replycount, postusername, postuserid, lastposter, dateline, FROM thread WHERE forumid = \"$forums\" ORDER BY threadid DESC LIMIT $limit";

PHP Code:


			$limit = 10;
// $forums = 19;

$sql = 'SELECT * FROM thread ORDER BY threadid DESC LIMT ' . intval($limit) . '';

Hooper · #3 10-23-2003, 01:37 AM

Hi Brad,

Now all I was wanting to do is just change the forums in which it grabbed the data that I already had. It appears you are grabbing all data from all forums. Am I incorrect? The WHERE forumid = \"$forums\" needed to equal all. Same data being pulled as I have it though.

Link14716 · #4 10-23-2003, 01:44 AM

You said $forums needed to equal all? All forums or all what?That query grabs all the threads regaurless to the forum it was posted in. Isn't that what you wanted?

Hooper · #5 10-23-2003, 01:49 AM

Original question,

How do I tell the following sql query to grab from all forums? Or set
$forums to all?

$limit=10 ;
$forums= 19 ;

$sql = "SELECT threadid, title, forumid, replycount, postusername, postuserid, lastposter, dateline, FROM thread WHERE forumid = \"$forums\" ORDER BY threadid DESC LIMIT $limit";

The query asks for certain items from whatever forum is defined by $forums. I am asking for the same items to be called from all forums. So SELECT threadid, title, forumid, replycount, postusername, postuserid, lastposter, dateline, FROM thread is the data I want, and the forums I need are from all. Not 19.

So I was thinking this would work but it doesn't seem to.

$sql = "SELECT threadid, title, forumid, replycount, postusername, postuserid, lastposter, dateline, FROM thread WHERE forumid = "\*\" ORDER BY threadid DESC LIMIT $limit";

Thank you,
Hooper