how i "select" form database
 

hi all'
i need to "SELECT" status of forum (old\new) forom database..
i know SQL but i dont find the table and field.
please help.
thanks.

Sorry but i don't understand your question.

i build mod and in the mod i wanna to "SELECT" from mysql databast, the status of forums...
i try and i dont success.
plz help.
thx.

Sorry but i still don't understand. Can you give examples of what you have been trying?

I think what he means is that he wants to select the status of a thread for a forum... I don't think that's done through the database, though. I think that's calculated from the newest date and determines if it's a new post or not...

no i mean to the forum_new forum_old status...
can you help me?
thx.

So, you want a query to tell whether there are new posts in a forum or not (which is what the forum_new forum_old tells)? Red Blaze is correct in that you need to look at some information regarding the user and whether they have 'read' a forum or have it 'marked as read' or not. There is no field to grab the info out of.

so how i do it?
how i tell whether there are new posts in a forum or not ?
thx.

Where do you want to do this? In what script?

i want put it in other template..