Combine these 2 queries?

[Boofo]

Can someone please tell me if the 2 following queries can be combined into one to pull out both pieces of information? And if so, how?

$popularreply=$DB_site->query_first("SELECT * FROM thread ORDER by replycount DESC LIMIT 1");

and:

$popularview=$DB_site->query_first("SELECT * FROM thread ORDER by views DESC LIMIT 1");

[Admin]

No, they can't be.

[Boofo]

Thanks, Chen. I kind of figured that, but thought it was worth a try.

[Boofo]

Is there a way to keep either one of those from being viewed by users that don't have permissions to view them? Like for a private forum and have it default to a second choice that is not private forums for those who can not view them?

[Admin]

Yes but it will add at least 3 more queries. If you want I'll give you the code.

[Boofo]

Yes, please, would you? I want to look at it and study it. I'll go ahead and use it since my forum is not very busy yet. :)

Originally posted by FireFly
Yes but it will add at least 3 more queries. If you want I'll give you the code.

[Boofo]

Any luck on the code yet, Chen? :)

[Admin]

Oops, forgot. Use this function:
https://vborg.vbsupport.ru/showthread.php?s=&threadid=41934

[Boofo]

Can't say that I haven't had others feel the same. :( :)

Thanks for the code. I'll see if I can figure out how to use it.