Bluezep Posted September 11, 2009 Share Posted September 11, 2009 Just like the above. how any common forum storing history of thread user posted? 1. in mysql table on "profile user table" in history column as array OR 2. create one table specially for history(with this one , there will be so many table because one user may make one table-which is maybe not practical)? i'm asking it because "making shoppping cart tutorial"-which is similiar- using session which is not practicall. when userbrowser close, history lost too. i think webmaster practically storing history in database and using cookies as filter for SELECT and UPDATE database. am i wrong? i just don't know how to store it in mysql as an array. Quote Link to comment https://forums.phpfreaks.com/topic/173862-quiz-how-to-storing-history-peruser-like-in-common-forum/ Share on other sites More sharing options...
Bluezep Posted September 11, 2009 Author Share Posted September 11, 2009 the method i've know so far for this problem is: create one table for history. it contains 1 column for user id and 1 column for topic id. and it stand for intermediate between userid table and topic table. so we will have 3 table, one for userid, one for history, one for topic. i wonder if there is any other method. and i wonder if mysql can contain array in column value. Quote Link to comment https://forums.phpfreaks.com/topic/173862-quiz-how-to-storing-history-peruser-like-in-common-forum/#findComment-916532 Share on other sites More sharing options...
fenway Posted September 12, 2009 Share Posted September 12, 2009 No, you've set it up correctly. Quote Link to comment https://forums.phpfreaks.com/topic/173862-quiz-how-to-storing-history-peruser-like-in-common-forum/#findComment-917349 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.