4 replies to this topic

[BudmannG]

Hi Visible,
I was wanting to know how many data base qurries I can put in one block? Say I want to pull from the ibf_topics and ibf_forums. Is this possible to do without error?

Thanks, Bud

[visiblesoul]

BudmannG said:

Hi Visible,
I was wanting to know how many data base qurries I can put in one block? Say I want to pull from the ibf_topics and ibf_forums. Is this possible to do without error?

Thanks, Bud

Not sure what you mean exactly. You can put as many queries as you like in a MKPortal block. But what you want to do would only take one query..

SELECT t.table1, t.table2, f.table1, f.table2 FROM ibf_topics AS t, ibf_forums AS f

[BudmannG]

Thank you, I will give that a go.

[visiblesoul]

Keep in mind that usually you will want to pull related data from both tables by comparing IDs...

SELECT t.table1, t.table2, f.table1, f.table2 FROM ibf_topics AS t, ibf_forums AS f
WHERE t.id=f.id

and sometimes you will need to use a JOIN statement to pull the data.

[BudmannG]

I added the forum names to the "ipb21_lposts_table_21". I didn't have to modify it much, I just added f.name to the querry and it works great.
The one I am having major trouble with is the last post icon. Still haven't figured that one out yet.
I will get a screen shot up ASAP!