almightyegg Posted February 10, 2007 Share Posted February 10, 2007 If I want to <b>bold</b> a forum title when a new message has been posted, how would I make a code to see whether all the posts in the forum have been viewed? Quote Link to comment https://forums.phpfreaks.com/topic/37902-just-curious/ Share on other sites More sharing options...
only one Posted February 10, 2007 Share Posted February 10, 2007 your gonna have to make a new table, then insert the person name and the topic id, pretty simple Quote Link to comment https://forums.phpfreaks.com/topic/37902-just-curious/#findComment-181428 Share on other sites More sharing options...
almightyegg Posted February 10, 2007 Author Share Posted February 10, 2007 what if there are 1 million posts and 1 million members there will be 1,000,000,000,000 rows....thats a bit extravogent :-\ Quote Link to comment https://forums.phpfreaks.com/topic/37902-just-curious/#findComment-181431 Share on other sites More sharing options...
wildteen88 Posted February 10, 2007 Share Posted February 10, 2007 or add a column to the users table called topic_views then everytime a user views a topic you update the field with the topics id. You're best of separating each topic id with a comma. Then you select the contents from the topic_views field in the users table and explode the ids into an array called viewd_topics. Then when you loop to show the topics you check to see if the id of the current topic being pulled is in the viewd_topic array. If it is you dont bold the topic title, If it isnt you bold it. Quote Link to comment https://forums.phpfreaks.com/topic/37902-just-curious/#findComment-181432 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.