Hi guys.

I need some help with a client of mines website.

Basically, the front page has a simple form that captures (name, email, and tel etc), and the price of their home.

On the second page, the information from the first page is stored on a Mysql database, and the customer is given an offer for their home.

They are presented with another form that asks if they accept the offer or not.

This then updates the Mysql database if they click 'yes' 'no' or 'maybe'.

The problem I am having is the client has now introduced a third party into the equation.

As well as the system I have developed, they also want the information, including the second set of information to be submitted via an iframe to another company.

At the moment I have created a third page, which asks the user to confirm their information.

Obviously this is not ideal, as not every customer is not going to resubmit their details.

Is there anyway I can build a timer of some sort into my database that waits 10 mins or so to see if the customer clicks 'yes' 'no' 'maybe', and then submits it to the other companies database?

The code they have given me looks like this:-

CustomEnquiry.aspx?NM=<? echo $name; ?>&EM=<? echo $email; ?>&PH=<? echo $tel; ?>&PC=<? echo $postcode; ?>&VL=<? echo $propvalue2; ?>&BMV=<? echo $bmvpercentage; ?>&OF=<? echo $acceptbmv; ?>

the echo $'s, are my variables, but they need all of this info sent across.

Hope someone can help.

Is there anyway I can build a timer of some sort into my database that waits 10 mins or so to see if the customer clicks 'yes' 'no' 'maybe', and then submits it to the other companies database?

Nope, HTTP doesn't work like that. If it doesn't happen there and then it isn't going to happen.

I'm a newbie so take what I say with a grain of salt, but could you create a cookie that times out in 10 minutes? When the cookie expires the data could be removed from the database. Feel free to tell me if this is a retarted idea, I'm here to learn! =)

HTTP is a disconnected protocol. Once a page is served to the client the connection is finished and no further communication occurs until another page is requested by the user.
Cookies are passive devices, simply clientside text files that have no means of interaction with the server.

What you need to accomplish will need user action to trigger.

Id personally have it all in the DB like you do now and have a Created TIMESTAMP

Id then ( on a linux box ) have a crontab that ran every 1minute and executed a PHP file that would look at the DB, Take the rows that are older than 10 minutes.

Do summat with the data ( send it to the 3rd party or update anotehr table )
and then delete it.

Originally Posted by sess4561

Is there anyway I can build a timer of some sort into my database that waits 10 mins or so to see if the customer clicks 'yes' 'no' 'maybe', and then submits it to the other companies database?

I think there's something here I'm not understanding. Is there a reason why you cannot submit the data when the user click yes or no?

Wow, I have a lot to learn...