I'm creating an application which has multiple users, with their own logins etc etc.
>From it, they have a number of links to external websites, to which I need to pass certain details, e.g. http://somewebsite.com/index.php?username=bob <http://somewebsite.com/index.php?username=bob&password=fred> &password=fred For management purposes, I am wanting to have the overall URL in a MySQL table, and want to be able to use that to get the appropriate variables from another table. So I have: Table: Websites ID Name Website 1 Somewebsite http://somewebsite.com/index.php?username=$username <http://somewebsite.com/index.php?username=$username&password=$password> &password=$password 2 Anotherwebsite http://anotherwebsite.net/login.php?agent=$agent 3 Agreatwebsite http://agreatwebsite.com/index.php?user=$user <http://agreatwebsite.com/index.php?user=$user&id=$id> &id=$id Table: User_Website_Details User Website_ID Variable Value Bob 1 Username Bob Bob 1 Password Fred James 2 Agent 03658264 Greg 3 User Bob_fred Greg 3 Id 49y5h9-845yf9 How can I get the values from the user's individual details into the required output? Cheers Nunners