This is my first post here, and hope you can help me. I will try and explain what I need to do, and apologise in advance if this goes on a bit
Step 1: Pass Parameters from the database (via URL) to specific page on an external site. (with the agreement of the external site owners)
If all parameters have a value, then the user is automatically logged in to the external site and all is fine. This works perfectly already
Step 2: If one specific parameter in Step 1 is empty (which it will be the first time each user clicks the link), then the page the parameters are sent to generates a value and sends it back to me.
I need to write the new value directly into a database table and send a confirmation string straight back once it is written in. (this is a simple y/n parameter)
Once this is done, the user is automatically logged in (as per step 1)
The following times the user clicks the link, all parameters are complete and so they log in automatically.
I am struggling with how to write the received variable into the database and send the confirmation.
All of this has to be done without it being visible to the end user (ie: the scripting happens automatically when the link is clicked)
Can anyone point me in the right direction on this, as I am seemingly going round in circles.
Many many thanks in advance