I tried this, it's actually clever, but there's a flaw I guess. Since the extract is done when logging in, the follow link will still appear for all the users you will follow after, and disappear only when re-logging in.
Le jeudi 14 juin 2012 14:40:16 UTC+2, JonStark a écrit : > > I have a table with the following fields : > > id follower_id following_id > > So when a user clicks "follow" on an other user's profile, an entry like > this is created : > > 15 1 3 > > meaning user with id 1 follows user with id 3. > > If user 3 follows 1, then an entry like > > 16 3 1 > > is created. > > But, in order to prevent users for following many time a same user, > leading to entry such as : > > 17 3 1 > 18 3 1 > 19 3 1 > > and so on, I want to replace "follow" by "unfollow" if the entry is > already saved. > > So my question is : how can i "scan" the table to check if an entry as > both X as follower_id AND Y as following_id ? > > Thanks a lot. > Le jeudi 14 juin 2012 14:40:16 UTC+2, JonStark a écrit : > > I have a table with the following fields : > > id follower_id following_id > > So when a user clicks "follow" on an other user's profile, an entry like > this is created : > > 15 1 3 > > meaning user with id 1 follows user with id 3. > > If user 3 follows 1, then an entry like > > 16 3 1 > > is created. > > But, in order to prevent users for following many time a same user, > leading to entry such as : > > 17 3 1 > 18 3 1 > 19 3 1 > > and so on, I want to replace "follow" by "unfollow" if the entry is > already saved. > > So my question is : how can i "scan" the table to check if an entry as > both X as follower_id AND Y as following_id ? > > Thanks a lot. > -- Our newest site for the community: CakePHP Video Tutorials http://tv.cakephp.org Check out the new CakePHP Questions site http://ask.cakephp.org and help others with their CakePHP related questions. To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/cake-php
