menriquez

by "converting to timestamp" i am guessing you mean using the value in a mysql database?? if so, the raw date format for mysql is yyyymmddhhmmss, which means that if you are loading a datetime/timestamp field into a database, convert the field to.. 20070307000000 before the insert...to round the date the easiest way to do that is to add 12 hours to the current time (military time), and if over 24 then add a day to your date field. hope this helps - mark

thanks corbin...after some further investigation i think your suggestion is the proper way to proceed. I think a PHP REST server connected to a C++ Builder/Delphi Indy 10 HttpClient form could make pretty quick work of the system. again, i thank you for you insights... regards, - mark

you should start your work here.... http://www.konstrukt.dk have fun, - mark

you should consider the elgg framework to kickstart you SN dreams... http://elgg.org/ good luck, - mark

hello, yes i have am contracted to build an "offline" app that basically will be used by field workers to add data from remote sites, then basically sync the data back to the mysql database that run the companies website. i could build a php webservice that accepts xml to post the new data, or i could just perhaps sync the mysql databasaes using some builtin mysql utilities. perhaps one of you knows of a pre-build framework solution for this problem...i would love to hear about it, or your opinions about an approach to this system. thanks, - mark

hey thxs! i would have not thought to have looked in wiki...your right of course i will have to get access to the MLS databases but your article is totally what i needed. - mark

it looks like you don't have a userid and password for your mysql_connect function call... - mark

yes i have been hired to build a site for some local realtors and i need to provide MLS search functionality in the site. i have been scouring the web for programming info and can't seem to find anything. looking at other sites, it looks like it is some sort of REST webservice call with the search parameters in a GET call, but i sure could use any suggestions or insights anyone here may have about doing this. advTHANKSance, - mark