I'm trying to make a php/mysql driven site

incorrect data gets pulled from database

[gmac6791]

I have tried to find answers but no luck, so it's time to ask directly! My objective is to create an online contract for clients to digitally sign, and have a unique URL for each one (ex: [mysite.com...]

Basically, this is how I envision it happening:

Back end

1. Webmaster will fill in a form with pertinent details of the contract.
   
2. Click a button to preview it, to make sure everything is filled in correctly.
   
3. Click a "publish" button, which will generate a unique URL for the client that contains the contract to be digitally signed.

Front end

1. Client will go to his unique URL to view and digitally sign the contract.
   
2. Click a "Submit" button, which will display a confirmation page that contains a link to the unique URL where the client's signed contract resides.

So far I've been able to achieve that. However, the one problem I'm having is that new contracts are not pulling the correct information from the database. They are pulling from the most recent information from the previous contract.

I'm new to doing this sort of thing, and have the feeling I need to start over from scratch, because the script I wrote just isn't working. Can someone give me some pointers for making each step of the process work, and especially how to make the db spit out the correct data for each unique contract?

I'm not asking for code to be written for me, just some guidelines for doing what I want to do.

Thanks.

[rocknbil]

must . . . see . . . code . . . will perish . . . without . . .code . . .

If you have **something** that's working "sorta," there's no reason to scrap it all.

Don't paste your whole script, just relevant parts. I am thinking probably the area that does the select statements that are not working should suffice.

After solving that, we can discuss why you shouldn't use a query string for this. :-)

[gmac6791]

Sorry for the delay in responding, but I ran into other snags that I need to work on, and maybe my above issue will get resolved from that. Thanks for the reply. I need to go start a new thread now, lol.