FUDforum: How To » How to get messages from a particular forum

Home » FUDforum » How To » How to get messages from a particular forum

Show: Today's Messages :: Polls :: Message Navigator

Re: How to get messages from a particular forum [message #30638 is a reply to message #30591]

Mon, 06 March 2006 16:01

acollins22

Messages: 11
Registered: June 2005
Location: Leicestershire, England

Karma:

Junior Member

Hi Ilia,

Thanks for the reply. I've been having a look at this but I'm a bit of a newbie here.

As a QnD hack I've tried this code in my SQL console.

SELECT fud26_msg.id as id
	FROM fud26_thread, fud26_msg
	WHERE fud26_msg.id = fud26_thread.id AND fud26_msg.apr = 1 AND fud26_thread.forum_id = 2
	ORDER BY id DESC

That works fine but if I put that code into my version of fetch_forum_msg it's no-go.

function fetch_forum_msg($arg=5)
{
$range = time() - 86400 * (float) $arg;

return _fud_msg_multi(0, "SELECT fud26_msg.id as id
	FROM fud26_thread, fud26_msg
	WHERE fud26_msg.id = fud26_thread.id AND fud26_msg.apr = 1 AND fud26_thread.forum_id = 2
	ORDER BY id DESC");
}

(I know this is a hack but I'm just trying to prove a point at first.)

If I look at _fud_msg_multi it's already doing a join, can I use that.

Sorry to be a bit vague here but I'm really out of my depth (though I'm learning fast). Please could you be more specific for me?

Thanks.

Andy.

Report message to a moderator

[Message index]

		How to get messages from a particular forum By: acollins22 on Fri, 03 March 2006 14:13
		Re: How to get messages from a particular forum By: Ilia on Sun, 05 March 2006 16:55
		Re: How to get messages from a particular forum By: acollins22 on Mon, 06 March 2006 16:01
		Re: How to get messages from a particular forum By: Ilia on Mon, 06 March 2006 18:14

Previous Topic:	login name
Next Topic:	PHP includes

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Nov 26 06:08:27 GMT 2024

Total time taken to generate the page: 0.04039 seconds