"iconid" from table "post" or "thread" ?

[mihai11]

Hi,



I see that there is an "iconid" in both tables – "post" and "thread". If I want to display the icon ID of the thread should I take the iconid of the first post from the tread or the iconid or the thread itself ?

As I see it now, the thread should not have an "iconid" field. The one from the first post should be enough.

Any thoughts ?



Regards,
Razvan

[EnIgMa1234]

As you can see from this post I have this icon https://vborg.vbsupport.ru/external/2010/01/19.gif

But when your posting a thread, it is differant because it needs to display in forumdisplay. My icon won't be shown but if you posted one it would be (In forumdisplay)

So basically that's why its needed in the thread table.

[mihai11]

As you can see from this post I have this icon https://vborg.vbsupport.ru/external/2010/01/19.gif

But when your posting a thread, it is differant because it needs to display in forumdisplay. My icon won't be shown but if you posted one it would be (In forumdisplay)

So basically that's why its needed in the thread table.

Sorry ... I still don't get it. If the icon needs to be displayed on forumdisplay, why not take the icon from the first post ? It is very easy to do that since the "thread" table contains a "firstpostid" field.

To be more clear: please give me a situation where the thread icon is different from the icon of the first post from the same thread.

[EnIgMa1234]

If it wasn't in the thread table, the would have to use an extra query in forumdisplay.

[mihai11]

If it wasn't in the thread table, the would have to use an extra query in forumdisplay.

I see .... so they are guaranteed to be the same ALL the time, right ? I can choose to use either of them .... it makes no difference.

[EnIgMa1234]

None whatsoever :)

If your looking to use the first post one, I would suggest using the thread table