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

well in case anyone has this problem i figured it out...RTFM, right? mysqli_result::fetch_fields http://us3.php.net/manual/en/mysqli-result.fetch-fields.php happy coding, and don't forget to free your memory! - mark

yeah i got the number of rows worked out, that was easy...but thxs anyway. i just need access to the field names...i suppose if i had to i could pass them in the object constructor, but i would rather just grab them from the query object. I know they are stored in there somewhere... - mark

yes i am trying to build a generic class that takes a result set from a mysqli->query and builds an object that contains the number of rows and an 2-d associative array with the field name as one of the array indexs. I used mysqli_field_count() to the the number of fields, but can't figure out how to get the field names. advTHANKSance, - mark

PDO seems pretty groovy, I'll hack into it a bit... thanks for your quick reply! - mark

yes I was wondering if anyone knew of a way to dump the entire result set of a "select" query into a standard php arrray (without the obvious "loop through it and build your own") so I can use some of those nifty php array functions? thxs, - mark

never mind...found the perfect solution here. http://phpbuilder.com/snippet/detail.php?type=snippet&id=394 thxs everyone for their help - mark

oh never mind the used_id field was an integer not string...sorry - mark