Re: [PHP-DB] Creating an INDEX on multiple tables?

2010-10-22 Thread Ron Piggott
I have moved the GROUP BY outside now Chris. In the queries that make up the UNION ALL (such as below) is there a way to only SELECT matches that are 70% or greater based on the users input? Right now each and every listing is a search result. Ron === SELECT

[PHP-DB] [PHP5 AdoDB] Correct return value after oracle package function call should be a string and I get a number instead.

2010-10-22 Thread Andrew Raimondi
Hello. I'm using PHP5 and ADODb(could not find a version number for the life of me, the closest thing I could find is an old-changelog.htm file topping version 3.92.22 well buried in a docs folder). I have this php code: /*getTitoloFromID si riferisce alla tabella CONF_RELAZIONI!!!*/

[PHP-DB] big table / hadoop / map reduce

2010-10-22 Thread Artur Ejsmont
Hi there guys and girls Have anyone came across any reasonable explanation / articles on how hadoop and map reduce work in practice? i have read a few articles now and then and i must say i am puzzled am i stupid or they just cant find an easy way to explain it? :P What i would hope for is

Re: [PHP-DB] big table / hadoop / map reduce

2010-10-22 Thread Andrés G . Montañez
Hi Artur, Here is an article on wikipedia: http://en.wikipedia.org/wiki/MapReduce And here are the native implementations in php: http://www.php.net/manual/en/function.array-map.php http://www.php.net/manual/en/function.array-reduce.php The basic idea is to gather a lot of data, from several

Re: [PHP-DB] big table / hadoop / map reduce

2010-10-22 Thread Artur Ejsmont
hehe sorry but this does not help :-) i can google for wikipedia definitions. I was hoping for some really good articles/examples that would put it into enough context. I would like to have good idea when it could be useful. So far had no luck with that. Its like with design patterns ...

Re: [PHP-DB] big table / hadoop / map reduce

2010-10-22 Thread Andrés G . Montañez
Imagine you have to get track of some kind of traffic, for example, ad impressions; lets supose that you have millions of those hits; you will have to have a few servers to receive the notifications of the impression of an ad. After the end of the day, you will have that info across a bunch of

[PHP-DB] How to Sync MySQL with iPhone or Google Contacts

2010-10-22 Thread listread
Hey all! Does anyone know how to go about syncing a MySQL db with an iPhone over the internet? An alternative would be syncing with Google Contacts, which then could sync with the iPhone. I think Google Contacts uses Exchange Server to sync with devices. Thanks! - Ron -- PHP Database

Re: [PHP-DB] How to Sync MySQL with iPhone or Google Contacts

2010-10-22 Thread Karl DeSaulniers
I believe there is a MySQL for the iphone iMy? http://forums.mysql.com/read.php?58,249718,249718 You'd probably want o use JASON or an equiv. to talk back and forth with your database and app. At least thats the consensus I'm finding on posts about it. HTH Karl On Oct 22, 2010, at 11:21