The Arcive of Official vBulletin Modifications Site.It is not a VB3 engine, just a parsed copy! |
|
#1
|
|||
|
|||
![]()
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:
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 |
#2
|
|||
|
|||
![]()
Anyone, or is this not possible ?
Thanks ![]() |
#3
|
|||
|
|||
![]()
Try making projects your primary table in the query.
|
#4
|
|||
|
|||
![]()
Thanks sussed it.
|
![]() |
|
|
X vBulletin 3.8.12 by vBS Debug Information | |
---|---|
|
|
![]() |
|
Template Usage:
Phrase Groups Available:
|
Included Files:
Hooks Called:
|