Re: [PHP-DB] SELECT string

2007-04-23 Thread bedul
cmiiw.. since i don't the visual what u said bellow - Original Message - From: "Ron Piggott" <[EMAIL PROTECTED]> To: "PHP DB" Sent: Tuesday, April 24, 2007 11:31 AM Subject: [PHP-DB] SELECT string > > I am looking for help to write a SELECT syntax to help me process a > directory searchi

[PHP-DB] SELECT string

2007-04-23 Thread Ron Piggott
I am looking for help to write a SELECT syntax to help me process a directory searching query tool I am developing. If you start at http://www.actsministrieschristianevangelism.org/ministrydirectory/ and under 'Step 1:' click Business a form is displayed. My question is how would you generat

Re: [PHP-DB] Is there any I can do to copy data from a mysql database to access database?

2007-04-23 Thread Luchino - Samel
There is a "tool" in Access that can connect an access database to any type of database [via ODBC]. It can be used as a table, so you can make all query rigth the way as other table. i'm sorry but i don't remember the "tool" name. Hope this will help. 2007/4/23, Steve Smith <[EMAIL PROTECTED]>:

RE: [PHP-DB] Forking and database connections

2007-04-23 Thread Dwight Altman
Glad to help. I was actually interested in your post because of forking versus threading. I still haven't found anything except for PHP-GTK but it may help your database related performance if it is added/exists in PHP. Regards, Dwight > -Original Message- > From: Chris Verges [mailto:[EM

Re: [PHP-DB] Forking and database connections

2007-04-23 Thread Chris Verges
For anyone interested in following the progress of this forking/PEAR::DB issue, see http://pear.php.net/bugs/bug.php?id=10813. Thanks, Chris -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] Forking and database connections

2007-04-23 Thread Chris Verges
Hey Dwight, After getting your first e-mail, I started adding the PEAR::DB persistent connection code. Unfortunately, it yielded the same results that I was getting before. At a hunch, I created a second proof-of-concept script that uses the mysql_* functions in the PHP base. For each of these,

RE: [PHP-DB] Forking and database connections

2007-04-23 Thread Dwight Altman
To use a PEAR::DB persistent connection, try $db = DB::connect($dsn, TRUE); or $db = DB::connect($dsn, true); Googled for "pear::db persistent connection" and got http://vulcanonet.com/soft/?pack=pear_tut Regards, Dwight > -Original Message- > From: Dwight Altman [mailto:[EMAIL PROTECTE

[PHP-DB] Is there any I can do to copy data from a mysql database to access database?

2007-04-23 Thread Steve Smith
I have a mysql database and would like to be able to copy the data from that to my access database. If there something that is freeware to do this? Or maybe someone has some code that might do this for me? Thanks in advanced. Steve -- PHP Database Mailing List (http://www.php.net/) To unsubsc

RE: [PHP-DB] Forking and database connections

2007-04-23 Thread Dwight Altman
Good point. Anything (children or parent) sharing the connection will get it closed on them. I was looking up persistent connections, then I thought you could just address the way you used the pcntl_* functions. I use mysql_* directly (where mysql_connect "Opens or reuses a connection to a MySQL

[PHP-DB] PDO prepared statements sometimes returns empty resultset

2007-04-23 Thread Emil Ivanov
Hi, I'm trying to get some data form a MySQL db using PDO and prepared statement, but I noticed that sometimes it fetches an empty result set, but sometimes does what it's supposed to do - returns the whole result set. The environment is WinXP SP2 Home, Apache 2.2.4, PHP 5.2.1 and MySQL 5.0.2

Re: [PHP-DB] Forking and database connections

2007-04-23 Thread Chris Verges
Hey Dwight, Thanks for the replies! When the first child thread closes, all of the DB connections seem to close. That is, the $db->execute() statements will fail in the child threads after the first child thread closes. It's almost as though separate connections are not being made, but they are

RE: [PHP-DB] Forking and database connections

2007-04-23 Thread Dwight Altman
Actually I suppose you need to loop with foreach to wait on all children before attempting any $db->execute, then after your foreach loop, get your $db and execute. Regards, Dwight > -Original Message- > From: Dwight Altman [mailto:[EMAIL PROTECTED] > Sent: Monday, April 23, 2007 10:09 AM

RE: [PHP-DB] Forking and database connections

2007-04-23 Thread Dwight Altman
http://php.he.net/manual/en/function.pcntl-fork.php says 'The reason for the MySQL "Lost Connection during query"...' like what you concluded, although they grab a new $db connection in the first for loop "} else if ( $pid ) {" I bet a child closes the one you create after the for loop while the pa