vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vB3 Programming Discussions (https://vborg.vbsupport.ru/forumdisplay.php?f=15)
-   -   sql problem (sorta! :)) (https://vborg.vbsupport.ru/showthread.php?t=44246)

merk 10-03-2002 12:45 PM
sql problem (sorta! :))
 
Code:
SELECT MAX(thread.title) as ttitle,MAX(thread.dateline) as dateline,MAX(thread.threadid) as threadid,MAX(thread.replycount) as comments,MAX(thread.lastpost) as lastpost,forum.forumid,forum.title,forum.description,forum.parentid FROM thread
INNER JOIN forum USING (forumid)
GROUP BY forum.forumid
HAVING forum.parentid=8
ORDER BY dateline DESC
This returns the correct result the first time (the forum that was updated the latest), with the correct name of the latest thread.

But all subsequent forums that it returns(still in the correct order of latest "thread"), it returns the first thread of that forum, not the latest.

I can do it with a sub-select, but mysql doesnt support that. Any thoughts?

merk 10-03-2002 10:43 PM
Okay, looking through my code, i see my max() is wrong.

Max returns the thread title that has the "highest" name, ie, starts with a W/X/Y/Z..

Which is _not_ what i want :)

I had it working before, but there was a SQL query per entry, which added around 24 queries per page, which i dont want to do :(

Any ideas? :D


All times are GMT. The time now is 11:27 PM.

Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.

X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.00895 seconds
  • Memory Usage 1,708KB
  • Queries Executed 10 (?)
More Information
Template Usage:
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (1)bbcode_code_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (2)printthreadbit
  • (1)spacer_close
  • (1)spacer_open 
Phrase Groups Available:
  • global
  • postbit
  • showthread
Included Files:
  • ./printthread.php
  • ./global.php
  • ./includes/init.php
  • ./includes/class_core.php
  • ./includes/config.php
  • ./includes/functions.php
  • ./includes/class_hook.php
  • ./includes/modsystem_functions.php
  • ./includes/class_bbcode_alt.php
  • ./includes/class_bbcode.php
  • ./includes/functions_bigthree.php 
Hooks Called:
  • init_startup
  • init_startup_session_setup_start
  • init_startup_session_setup_complete
  • cache_permissions
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • printthread_start
  • bbcode_fetch_tags
  • bbcode_create
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • printthread_post
  • printthread_complete