Help needed with Filemaker and mySQL

[Seinn]

Here's my problem. I work for a comunity group and have developed a very substantial database to track clients and various opportunites. The database as I mentioned is very substantial. However on our website we use a mySQL database to show people various opportuniities which exist that they may be interested in. What I need to do is as follows.

1. Connect to the sql database automatically.

2. Query the sql database to see if the opportunity is on the site. If not create a new record and upload the data from the relivant table in Filemaker.

3. If the opportunity is there, check the last posted date and if that differs from Filemaker, is. is older than on filemaker update the sql fields.

This sounds as it should be possible to me however I am not to sure what way to do it. I am very familiar with Filemaker but not to up on sql. I have a friend that will help with teh sql part but I need help in how to address this.

Is there anyone out there who can offer advice or would be willing to help me out on this via e-mail until I get it working.

Any help is really appreciated.

Thanks

Ian

[orenco]

I know that the webpage language PHP can communicate with both mySQL and FM7 Advanced. I haven't used PHP with FM7 yet, so I can offer no advice other than this. I would suggest using PHP to create an internal webpage which can access both databases and act as a middleman interface between them. You will need to find the FM plugin for PHP.

[Seinn]

I should have said that Filemaker is running locally. The web server is remote. So I am looking for a solution to connect remotely to mySQL and do the above.

[orenco]

Still, my best bet would be on PHP. Check out the PHP forum and the book "PHP and mySQL for Dynamic Web Sites" by Larry Ullman.

[fishbone]

food for thought: when i was reading this post i saw one of the filemaker ads by google at the top of this screen (hence scroll up and you may see it (random rotation))

it read "filemaker wb hosting: Looking for a way to deploy online? we can help"

[Faiz]

I am faced with the same situation and am in quite a fix. Did you find a solution for this? Please tell me if you did. Any and all help will be appreciated.

Faiz