"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

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]

Originally Posted by EnIgMa1234

As you can see from this post I have this icon

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]

Originally Posted by EnIgMa1234

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