newbeee Posted January 3, 2009 Share Posted January 3, 2009 I have nothing on paper just the idea to allow members of my site to see which members viewed their profile, where would i start as i have tried to think how this would be possible but can not find the best way. i first thought of having a 'blog' table i think thats what its called with all the memberID's that viewed that member. i.e. CREATE TABLE IF NOT EXISTS `whoviewedme` ( `id` bigint(20), `username` text NOT NULL, `viewedby` blob NOT NULL ) and the viewedby would have all the id's seperated by a comma. but what happens when two different members view the same profile, one of these id's would not be placed in the database? or would it corupt the data? anyone got any suggestions on how i should do this Quote Link to comment Share on other sites More sharing options...
fenway Posted January 4, 2009 Share Posted January 4, 2009 Don't try to store arrays in a single field... create one record for each tuple. Quote Link to comment 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.