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..

That's actually determined by a vb function. It isn't saved in the database.

Templates are just the way to present the data already collected in a script. If the script that is calling the template have not set a variable (or it is simply not available in the context), then you will first need to populate that data. Hence the question in which script you want to do something.

look,
i do script that select the dorum name and forum id and insert them to other table that i careat, this table's name: forumlistmy.
after this i do query_read to select all the forum name and forum id and show them on another template that i created..
and i success but i want to insert the status of forum (forum_new forum_old)
and select them on the template..
plz help me.. thx.

plz?

someone plz?