how i "select" form database

[MAORBARI]

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.

[Marco van Herwaarden]

Sorry but i don't understand your question.

[MAORBARI]

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.

[Marco van Herwaarden]

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

[Red Blaze]

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

[MAORBARI]

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

[Lynne]

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.

[MAORBARI]

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

[Marco van Herwaarden]

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

[MAORBARI]

i want put it in other template..

[Gio~Logist]

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

[Marco van Herwaarden]

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.

[MAORBARI]

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.

[MAORBARI]

plz?

[MAORBARI]

someone plz?