March 31st, 2013, 07:29 PM
Yes, that helps a lot.
In the link to the user choices, pass the user ID (or any unique identifier) as a URL parameter:
You can then fetch the ID from the URL and use it in your queries:
So the only difference is that the user ID now comes from the $_GET array rather than the $_SESSION array.
$user_id = $_GET['user_id'];
Note, however, that you mustn't insert any user-defined parameter directly into your query, because this can lead to SQL injections. Check the first link in my signature in case you're not familiar with that risk.
I also wonder why you have both the user ID and the user name in your table. Don't you have a separate table for the users?
March 31st, 2013, 07:32 PM
Thanks Jacques I will work on it you are a life saver. Plus I set up the table that way because I was struggling with join and union, this is all still local but will fix thanks.
March 31st, 2013, 09:18 PM
Was able to get everything working thanks Jacques