FUDforum: How To » consistency help please.

Home » FUDforum » How To » consistency help please.

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

Re: consistency help please. [message #31688 is a reply to message #31683]

Thu, 11 May 2006 23:18

andy_scouser

Messages: 76
Registered: June 2003

Karma:

Member

Yes it does...sorry im not a coder.
$pc = ceil(q_singleval('SELECT count(*) FROM '.$tbl.'msg WHERE file_id>0') / 10);

Should i change this to

$pc = ceil(q_singleval('SELECT count(*) FROM '.$tbl.'msg') / 10);

$c = q('SELECT m.id, m.foff, m.length, m.file_id, f.message_threshold, f.id FROM '.$tbl.'msg m INNER JOIN '.
$tbl.'thread t ON m.thread_id=t.id INNER JOIN '.$tbl.'forum f ON t.forum_id=f.id WHERE m.file_id>0 LIMIT 100');

and change this to

$c = q('SELECT m.id, m.foff, m.length, m.file_id, f.message_threshold, f.id FROM '.$tbl.'msg m INNER JOIN '.
$tbl.'thread t ON m.thread_id=t.id INNER JOIN '.$tbl.'forum f ON t.forum_id=f.id LIMIT 100');

No giggling thanks for the reply too!

[Updated on: Thu, 11 May 2006 23:23]

Report message to a moderator

[Message index]

		consistency help please. By: andy_scouser on Thu, 11 May 2006 09:13
		Re: consistency help please. By: Ilia on Thu, 11 May 2006 21:21
		Re: consistency help please. By: andy_scouser on Thu, 11 May 2006 23:18
		Re: consistency help please. By: Ilia on Sun, 14 May 2006 15:02
		Re: consistency help please. By: andy_scouser on Sun, 14 May 2006 17:36

Previous Topic:	Member listing
Next Topic:	Another question about cookies and session

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Nov 27 08:48:07 GMT 2024

Total time taken to generate the page: 0.03793 seconds