[PHP-DB] Convert String to Array

2005-09-29 Thread Ng Hwee Hwee
Hi guys, this looks like a very simple problem but i really have no idea how to do it.. please help me! thanks! my MySQL database has a table of which 2 fields are as follow T100FieldNmT100Value == = vehMdlCd[0] MER vehMdlCd[1] LEX ve

Re: [PHP-DB] joining tables in postgres

2005-09-29 Thread Miles Thompson
At 04:13 PM 9/29/2005, redhat wrote: anyone know of any good tutorials on simple joining of tables in Postgres using PHP? I did some Googling and didn't find anything satisfactory. thanks, Doug -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.ph

Re: [PHP-DB] adding to the current value

2005-09-29 Thread Justin Turner
...now don't I feel foolish. Thanks for your help. Hutchins, Richard wrote: You do it by: UPDATE my_table set field_1 = field_1 - 1 [...add any where statements here] Bastien pretty much answered your question because the example you provided was, in theory, correct. Besides, unless you're me

RE: [PHP-DB] adding to the current value

2005-09-29 Thread Hutchins, Richard
You do it by: UPDATE my_table set field_1 = field_1 - 1 [...add any where statements here] Bastien pretty much answered your question because the example you provided was, in theory, correct. Besides, unless you're messing with a production system, you could always just try out simple stuff like

Re: [PHP-DB] adding to the current value

2005-09-29 Thread Justin Turner
How can I do this? Bastien Koert wrote: yes From: Justin Turner <[EMAIL PROTECTED]> To: php-db@lists.php.net Subject: [PHP-DB] adding to the current value Date: Thu, 29 Sep 2005 16:26:00 -0400 I would like to increment the current value of a field X without having to retrieve field X be

RE: [PHP-DB] adding to the current value

2005-09-29 Thread Bastien Koert
yes From: Justin Turner <[EMAIL PROTECTED]> To: php-db@lists.php.net Subject: [PHP-DB] adding to the current value Date: Thu, 29 Sep 2005 16:26:00 -0400 I would like to increment the current value of a field X without having to retrieve field X beforehand. Can I do this? Example: UPDATE

[PHP-DB] adding to the current value

2005-09-29 Thread Justin Turner
I would like to increment the current value of a field X without having to retrieve field X beforehand. Can I do this? Example: UPDATE my_table set field_1 = (current_field_value -1) WHERE...blah, blah, blah == A. Justin Turner -- PHP Datab

[PHP-DB] Showing various result from a mysql query

2005-09-29 Thread Juan Stiller
Hi, im working on a php file that its supposed to retrieve data from a mysql database, to send it to a flash animation to show the results. Thing is that im testing some modifications to the code, so if there is more than one entry, it shows all the results. For some reason probably a mistake on t

[PHP-DB] joining tables in postgres

2005-09-29 Thread redhat
anyone know of any good tutorials on simple joining of tables in Postgres using PHP? I did some Googling and didn't find anything satisfactory. thanks, Doug -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] Showing various result from a mysql query

2005-09-29 Thread Juan Stiller
Hi, im working on a php file that its supposed to retrieve data from a mysql database, to send it to a flash animation to show the results. Thing is that im testing some modifications to the code, so if there is more than one entry, it shows all the results. For some reason probably a mistake on t

RE: [PHP-DB] Connecting to two MySQL databases

2005-09-29 Thread Miguel Guirao
I agree with this solution!! -Original Message- From: Micah Stevens [mailto:[EMAIL PROTECTED] Sent: Jueves, 29 de Septiembre de 2005 01:10 p.m. To: php-db@lists.php.net Subject: Re: [PHP-DB] Connecting to two MySQL databases I don't see a reason to duplicate the class code, just make i

Re: [PHP-DB] Connecting to two MySQL databases

2005-09-29 Thread Micah Stevens
Well, the class creation I screwed up on, but I think you should get the idea anyhow. -Micah On Thursday 29 September 2005 11:10 am, Micah Stevens wrote: > I don't see a reason to duplicate the class code, just make it keep track > of the $link variable, and each instance of the class can be a

Re: [PHP-DB] Connecting to two MySQL databases

2005-09-29 Thread Larry E. Ullman
I am working on an application that requires me to connect to two MySQL databases both hosted on the same server. I have an existing set of class files I created to handle the db connection to the main database. To connect to the second database, I duplicated my db class files and renamed t

Re: [PHP-DB] Connecting to two MySQL databases

2005-09-29 Thread Micah Stevens
I don't see a reason to duplicate the class code, just make it keep track of the $link variable, and each instance of the class can be a seperate connection.. Then you can do what you want: $db1 = new dbconn; $db2 = new dbconn; $db1->dbconn($host, $user, $pw); $db2->dbconn($host2, $user2, $pw2)

[PHP-DB] Connecting to two MySQL databases

2005-09-29 Thread Charles Kline
Hi all, I am working on an application that requires me to connect to two MySQL databases both hosted on the same server. I have an existing set of class files I created to handle the db connection to the main database. To connect to the second database, I duplicated my db class files and

[PHP-DB] ARG! Unable to connect to 10.2.0.1 Oracle database

2005-09-29 Thread Chuck
I am having problems connecting to Oracle 10.2 (64-bit) on Solaris 9 using Apache 2.0.54 and PHP 5.0.5 PHP Build: ./configure --prefix=/usr/local/php-5.0.4--with-apxs2=/usr/local/apache2/bin/apxs --enable-cli --enable-cgi --with-zlib --with-zlib-dir=/usr/local/lib --with-bz2 --with-gd --with-mysq