mssql form

raspis21

hi all,

I am in dire need of some help here.

What I have is an mssql database (we have it in place for our software) and I need to be able to update the customer information via a page on our intranet. It would be fairly straight forward for someone fluent in PHP Id' think.

Here is the scenario:

I need to have the rep be able to hit the webpage in their browser, enter in a phone number, display the current information about that account, and if the info is different than the current info, update the second database (I am not writing back to the live database at all, all changes are to be reviewed by me before updating the live DB.)

That is what needs to be done, now here is how the database is set up, and also the reason I can't seem to figure this out.

database one has a table called accounts. In the accounts table are all the usual company info; name, address, etc. There is also a column called contacts. The contacts column has a number that is the is actually a row number in the table contacts.

When a rep enters the phone number, I need to query database one, including the contacts table info. This isnt really the big deal.

The big deal I am running into is taking the info and changing to database two and updating the tables (exact same name as database one) with the info entered.

My question is how do I switch databases and then update the new info from database one in database two? If you have some code snippets, or even a word of advice I would be very grateful.

Thanks

dmrn

it's quit simple (i guess)

1 - connect

$msconnect=mssql_connect("MyServer70","sa","");

2 - select 1st DB

$msdb=mssql_select_db("DB1",$msconnect);

3 - Find out in the first DB what information you want

$msquery1="SELECT * FROM accounts WHERE id=789";

$msresults= mssql_query($msquery1);

$row = mssql_fetch_array($msresults);

4 - select 2nd DB

$msdb=mssql_select_db("DB2",$msconnect);

5 - Update in the 2nd DB the information

$msquery2="Update accounts SET phone=".$row['phone'].", location=".$row['location']." WHERE id=".$row[id];

$msresults= mssql_query($msquery2);

it´s only a small example ...