Re: [PHP-DB] bindParam OR bindValue

2010-12-28 Thread Artur Ejsmont
i am not 100% sure but should you not remove ' from around the variables to have (NULL, :f1, :l1 etc? prepared statements take care of escaping and quoting. http://www.php.net/manual/en/pdo.prepare.php does it help? art -- Visit me at: http://artur.ejsmont.org/blog/ -- PHP Database Mailing

Re: [PHP-DB] query help

2010-11-17 Thread Artur Ejsmont
well i guess you could do that. but it gets complicated after a while and there will be a lot of work and probably after a while you will get into some problems. You have to handle escaping, special types etc. Then what about performance? how to query the data ... using similar approach or is

Re: [PHP-DB] Reading from file

2010-11-02 Thread Artur Ejsmont
Return Values If only two parameters were passed to this function, the values parsed will be returned as an array. Otherwise, if optional parameters are passed, the function will return the number of assigned values. The optional parameters must be passed by reference.

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

2010-10-30 Thread Artur Ejsmont
this will be useful. Cheers. On 22 October 2010 13:27, Artur Ejsmont ejsmont.ar...@gmail.com wrote: 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

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

2010-10-30 Thread Artur Ejsmont
you can call map and reduce. Cheers. On 30 October 2010 15:51, Artur Ejsmont ejsmont.ar...@gmail.com wrote: sure that was a bit more helpful, thanks :) i was still wondering to what other use cases would that apply. This is a good article (best so far i guess): http://code.google.com/edu

[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 Artur Ejsmont
. Cheers. On 22 October 2010 12:14, Artur Ejsmont ejsmont.ar...@gmail.com wrote: 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

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

2010-10-21 Thread Artur Ejsmont
I dont think you can create such index across tables. If you are interested read up on sphinx. Im pretty sure you would be able to create what you need. Alternatively ... a super simplistic solution . create one extra search table with copy of the data and create index there? ;P hehehe +

Re: [PHP-DB] Books

2010-10-18 Thread Artur Ejsmont
the only book i can really recommend in this area is high performance mysql but its not for starters ..its excellent! art On 18 October 2010 15:06, Ethan Rosenberg eth...@earthlink.net wrote: Dear List - I posted part of this question on the general list.  I am posting here just in case

Re: [PHP-DB] RE: [phpXperts] No Warping in results [1 Attachment]

2010-07-23 Thread Artur Ejsmont
I guess the html/css is wrong. If you print all links in new TD elements or as nonbreakable test it will look like this. If you just use divs floating left instead then links will fill the space and wrap around. Also getting rid of it all together and simple list of a tags with some space between

[PHP-DB] anyone has experience with pgslq Cybercluster 2 ?

2010-06-01 Thread Artur Ejsmont
Hi there i just noticed announcement of cybercluster 2 release for postgres. http://www.cybertec.at/en/postgresql_news they say its open source but did not find downloads on their site ; ) Anyone has experinece with it? i loved postgres and used to work with it for a long time but lack of easy

Re: [PHP-DB] Need Help in error msg

2010-05-18 Thread Artur Ejsmont
May also be granted rights to login from '%' which will resolve to any host name except localhost. On 18 May 2010 08:24, Peter Lind peter.e.l...@gmail.com wrote: On 18 May 2010 09:19, nagendra prasad nagendra802...@gmail.com wrote: Hi All, I am getting t... It means that either the password

Re: [PHP-DB] MySQL: Creating a database with

2010-05-18 Thread Artur Ejsmont
You probably miss the mysql extension or have different one than you are calling. Please call ?php php_info(); ? in script to see what extensions are loaded. if there is some other module supporting mysql just use different way to run sql. otherwise you need to look into php.ini and see if

Re: [PHP-DB] Help with mysql data sorting using php

2010-05-17 Thread Artur Ejsmont
and that's it. Good luck. On 17 May 2010 08:18, nagendra prasad nagendra802...@gmail.com wrote: DB is like more then 500MB and it will grow day by day :) On Mon, May 17, 2010 at 12:46 PM, Artur Ejsmont ejsmont.ar...@gmail.com wrote: If the DB i...

Re: [PHP-DB] Session start

2010-05-14 Thread Artur Ejsmont
id also suggest to revisit the entire login script that you have attached, its a bit overly complicated. Keep amount of if statements to the minimum and you will not get lost. Try to keep it simple. Session is not a problem for you, just make a very simple set of rules when user is logging in,