clint Posted February 18, 2011 Share Posted February 18, 2011 Good morning I am trying to add an "add to contacts" button to the user profile page that is viewed by other users but I seem to be struggling to wrap my head around this one. I can create the search user page that populates a list of users based on search criteria and link to their respective profiles using GET. But now if I have a "add to contacts" button on their profile page, I am struggling with the code to insert this into a contacts table correctly. If the contacts table has a id column, user_id column and contacts_id column how do I insert the id of the user you are viewing into the contacts_id column? I should have something along these lines....: if (isset($_SESSION['user_id'])) $user_id = ($_POST['user_id']); $sql_insert = "INSERT into `contacts` (`user_id`,`id`,`date`) VALUES ('".$_SESSION['user_id']."','$id',now())"; mysql_query($sql_insert,$link) or die("Insertion Failed:" . mysql_error()); $user_id = mysql_insert_id($link); but that is not going to add the id as contact id for the profile being viewed. Should this be done totally differently? Any help in this regard would be highly appreciated. Apologies if I have not explained properly. Thank you 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.