I'm trying to set up a real estate search page. I can't connect directly to the multiple listing services' database (ms sql), but must instead upload it to my server (mysql) and then run daily updates to keep it synchronized. I'm hoping someone can provide some basic assistance or at least point me down the right path.
Obviously, the easiest way to do this would be to download the whole table (~70 megs), upload it to my server and then run daily queries from my server to reconcile new listings/changes, etc.
I can put together the actual search page, I just don't know how to set up the querying system (I use myphpadmin through my server).
(Is this possible through phpmyadmin, what sql queries, etc. cron?)
Many thanks from a newbie.