Help with query MySQL and PHP

2008-07-02 Thread axis
Hi, I want to create a new column or table from queries of the values of columns I( already have. My table is : PRODUCTS_TO_PRODUCTS_EXTRA_FIELDS products_id products_extra_fields_id products_extra_fields_value 1 1

how to stay connected to remote mysql server?

2008-07-02 Thread Can-Hua Chen
I am using syslog-ng to pipe syslog entries to a remote mysql server. I would like to stay connected to remote mysql server, always trying to reconnect if disconnected due to network problem. Is there some mysql-internal mechanism to do this? Or must I write a script to do so? If a script is necess

Re: Running 2 versions of MySQL on same server

2008-07-02 Thread up
No, because I fear that would break the existing customer php apps, which is the whole point of running two versions of MySQL. What I guess I need to know is if php's mysql and mysqli extensions can be made to recognize two different sets of client libs. Unless you're telling me that having

Re: Mysqldump turn off quotes

2008-07-02 Thread Dan Nelson
In the last episode (Jul 02), Martin Gainty said: > > How do I get mysqldump to turn off quotes e.g from > INSERT INTO "table" > to > INSERT INTO table http://dev.mysql.com/doc/refman/5.0/en/mysqldump.html#option_mysqldump_quote-names -- Dan Nelson [EMAIL PROTECTED] -- MySQL

Re: Running 2 versions of MySQL on same server

2008-07-02 Thread Curtis Maurand
Did you rebuild php against the 5.0 libraries as I suggested yesterday? If you didn't it will only recognize the 3.23 version. It will not be able to talk to the 5.0 version. Curtis [EMAIL PROTECTED] wrote: It would appear that the problem isn't getting MySQL 3.23 and 5.0 to run on the s

Re: Running 2 versions of MySQL on same server

2008-07-02 Thread up
It would appear that the problem isn't getting MySQL 3.23 and 5.0 to run on the same server with different ports and sockets, but rather getting mod_php to recognize both clients. phpinfo() shows only 3.23, since it's in the standard path. If anyone has experience getting two different vers

Mysqldump turn off quotes

2008-07-02 Thread Martin Gainty
How do I get mysqldump to turn off quotes e.g from INSERT INTO "table" to INSERT INTO table Thanks Martin Gainty __ Disclaimer and confidentiality note Everything in this e-mail and any attachments relates to the official business of Sender. This

RE: Queues on MySQL?

2008-07-02 Thread Jerry Schwartz
>-Original Message- >From: Waynn Lue [mailto:[EMAIL PROTECTED] >Sent: Tuesday, July 01, 2008 5:26 PM >To: Jerry Schwartz >Cc: MySQL List >Subject: Re: Queues on MySQL? > >>>Thanks for the suggestion--is that essentially using >>>http://www.php.net/posix_mkfifo within PHP? >>> >> [JS] Yes, t