I need to write a simple script that would let me run it off a crontab to:
1) Connect to a RETS URL using login data.
2) Fetch XML data using appropriate parameters.
3) And add (new) specific data onto the already designed MySQL database table.
4) you can use any existing RETS libraries to make this easier.
You need not work with PHP - any language is fine, but it must run on a lamp server. The end result data must be stored in the existing mysql database and in the appropriate fields.
If this works out then there will be a lot of work for you similar to this, I've been avoiding RETS projects until now. :)