Reply
Old 11-02-2009, 08:29 AM database problem
Experienced Talker

Posts: 44
Trades: 0
i have a site of a Clothing store .. the local database in the store is MSSQL but the database on server is MYSQL....
i want to make instant synchronization so when someone buy a cloth from the store it will be deleted from database (MSSQL) to ensure that it is bought.. i want also to remove it from the database of phpmyadmin at the same time.. so if anyone tries to buy it from the shopping card online he will find that this product is already sold..

so i need an instant synchronization program or an y other idea between mssql and mysql so any changes in mssql will chnage the database in phpmyadmin...
john_zakaria is offline
Reply With Quote
View Public Profile
 
 
When You Register, These Ads Go Away!
Old 11-02-2009, 09:21 AM Re: database problem
chrishirst's Avatar
Super Moderator

Posts: 22,214
Location: Blackpool. UK
Trades: 0
Unless the MSSQL server is accessible by the webserver and you create a PHP script that will update the changes, you can't.
__________________
Chris. ->> Links are advertising NOT optimising!! <<-
Growing old is mandatory - Growing up is optional
Code Samples | People Counting System | Bits & Bobs
chrishirst is online now
Reply With Quote
View Public Profile Visit chrishirst's homepage!
 
Reply     « Reply to database problem
 

Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are Off
Pingbacks are Off
Refbacks are Off





   
RSS Feed  Feeds: RSS   JS   XML
RSS Feed  Feeds for this forum: RSS   JS   XML

 



Page generated in 0.10402 seconds with 13 queries