Go Back   vb.org Archive > vBulletin 3 Discussion > vB3 Programming Discussions
  #1  
Old 02-19-2007, 10:56 AM
8utt 8utt is offline
 
Join Date: Aug 2004
Posts: 19
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default Merge Different Size Queries Possible ? How ?

I hope there is a solution to this as its been churning over in that big void in my head for long enough

I have a query that returns a list of results

Say

PHP Code:
select projects.uniqueidjobs.uniqueidresults.uniqueid from individualresults
left join results ON 
(individualresults.fromresultsid results.uniqueid)left join projects ON (results.projectid=projects.uniqueid)left join jobs ON (results.jobid jobs.uniqueid
This results me say 10 sets of results.

projectid, jobid, resultid
1,1,1
1,2,2
1,2,3
2,3,4
2,3,5
2,4,6
3,5,7
3,5,8
3,5,9
3,6,10


What I do with this is then create a explorer tree type javascript menu by comparing the previous values to determine at which level the item should be in the tree.

example

1
---1
------1
---2
------2
------3
2
---3
------4
------5
---4
------6
3
---5
------7
------8
------9
---6
------10

Now the problem with this is that is there is a project or job id present in the database but no results then the query does no return anything but I still wanted it to appear in the tree.

Say project 1 had a job number 3 but there were not any results yet.

How would I achieve this ?

My thought would be is it possible to merge 2 queries so that
you could have an output like


projectid, jobid, resultid
1,1,1
1,2,2
1,2,3
1,3,null
2,3,4
2,3,5
2,4,6
3,5,7
3,5,8
3,5,9
3,6,10

or something like that ?

I hope I've made it clear what my problem but as always any questions are welcome

Thanks

8utt
Reply With Quote
  #2  
Old 02-23-2007, 07:56 AM
8utt 8utt is offline
 
Join Date: Aug 2004
Posts: 19
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Anyone, or is this not possible ?

Thanks
Reply With Quote
  #3  
Old 02-23-2007, 10:25 AM
Marco van Herwaarden Marco van Herwaarden is offline
 
Join Date: Jul 2004
Posts: 25,415
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Try making projects your primary table in the query.
Reply With Quote
  #4  
Old 02-23-2007, 12:43 PM
8utt 8utt is offline
 
Join Date: Aug 2004
Posts: 19
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Thanks sussed it.
Reply With Quote
Reply

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


All times are GMT. The time now is 04:13 AM.


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.03353 seconds
  • Memory Usage 2,182KB
  • Queries Executed 13 (?)
More Information
Template Usage:
  • (1)SHOWTHREAD
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (1)ad_showthread_beforeqr
  • (1)ad_showthread_firstpost
  • (1)ad_showthread_firstpost_sig
  • (1)ad_showthread_firstpost_start
  • (1)bbcode_php
  • (1)footer
  • (1)forumjump
  • (1)forumrules
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (1)navbar
  • (3)navbar_link
  • (120)option
  • (4)post_thanks_box
  • (4)post_thanks_button
  • (1)post_thanks_javascript
  • (1)post_thanks_navbar_search
  • (4)post_thanks_postbit_info
  • (4)postbit
  • (4)postbit_onlinestatus
  • (4)postbit_wrapper
  • (1)spacer_close
  • (1)spacer_open
  • (1)tagbit_wrapper 

Phrase Groups Available:
  • global
  • inlinemod
  • postbit
  • posting
  • reputationlevel
  • showthread
Included Files:
  • ./showthread.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/functions_bigthree.php
  • ./includes/class_postbit.php
  • ./includes/class_bbcode.php
  • ./includes/functions_reputation.php
  • ./includes/functions_post_thanks.php 

Hooks Called:
  • init_startup
  • init_startup_session_setup_start
  • init_startup_session_setup_complete
  • cache_permissions
  • fetch_postinfo_query
  • fetch_postinfo
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • showthread_start
  • showthread_getinfo
  • forumjump
  • showthread_post_start
  • showthread_query_postids
  • showthread_query
  • bbcode_fetch_tags
  • bbcode_create
  • showthread_postbit_create
  • postbit_factory
  • postbit_display_start
  • post_thanks_function_post_thanks_off_start
  • post_thanks_function_post_thanks_off_end
  • post_thanks_function_fetch_thanks_start
  • post_thanks_function_fetch_thanks_end
  • post_thanks_function_thanked_already_start
  • post_thanks_function_thanked_already_end
  • fetch_musername
  • postbit_imicons
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • postbit_display_complete
  • post_thanks_function_can_thank_this_post_start
  • tag_fetchbit_complete
  • forumrules
  • navbits
  • navbits_complete
  • showthread_complete