[PHP-DB] [DB_DataObject] why is there no query($query, $params) method?

2005-05-09 Thread Thomas
Hi DB_DataObject uses PEAR::DB internally, which provides a nice query method with two arguments: the SQL statement (with placeholders) and a parameter array, so that I don't have to do any escaping etc. Is there any reason that this method signature is not supported by DB_DataObject? There is

[PHP-DB] R6025 Error

2005-05-09 Thread Ng Hwee Hwee
Hi all, I'm having a problem with a R6025 error. What happened is that I have a table generated using MySQL and PHP that displays all the registered customers. On the table header, i allow them to click on some links that can sort the table according to their preference. Sometimes, when users

RE: [PHP-DB] R6025 Error

2005-05-09 Thread Juffermans, Jos
Can you also send us the output generated by PHP? Ie the output HTML... Jos -Original Message- From: Ng Hwee Hwee [mailto:[EMAIL PROTECTED] Sent: 09 May 2005 10:48 To: PHP DB List Subject: [PHP-DB] R6025 Error Hi all, I'm having a problem with a R6025 error. What happened is that I

RE: [PHP-DB] Drop Down Menus

2005-05-09 Thread Miguel Guirao
Some body asked for it! -Original Message- From: chintan [mailto:[EMAIL PROTECTED] Sent: Jueves, 05 de Mayo de 2005 07:36 a.m. To: php-db@lists.php.net Subject: [PHP-DB] Drop Down Menus hey guys i wrote this code from another code of zend.php Can anyone tell me how do i update the value

[PHP-DB] [DB_DataObject] why is there no query($query, $params) method?

2005-05-09 Thread Kieran.Tully AT acm.org
On 09/05/05, Thomas [EMAIL PROTECTED] wrote: Is there any reason that this method signature is not supported by DB_DataObject? Perhaps because it doesn't make sense to wrap every DB method when you can already do $dataObject-getDatabaseConnection()-query(...) -- Kieran Tully, Software

[PHP-DB] Can't compile Oracle's 10g support in PHP5

2005-05-09 Thread Mário Gamito
Hi, I'm trying to compile PHP 5.04 with support to Oracle 10g, but i always get the error: checking Oracle version... configure: error: Oracle needed libraries not found Well, i think i have Oracle's libs in /home/oracle/product/10.1.0/db_1/lib/ At least i have a lot of .so there. How can i

[PHP-DB] Can't compile Oracle's 10g support in PHP5

2005-05-09 Thread Mário Gamito
Hi, I'm trying to compile PHP 5.04 with support to Oracle 10g, but i always get the error: checking Oracle version... configure: error: Oracle needed libraries not found Well, i think i have Oracle's libs in /home/oracle/product/10.1.0/db_1/lib/ At least i have a lot of .so there. How can i

Re: [PHP-DB] [DB_DataObject] why is there no query($query, $params) method?

2005-05-09 Thread Thomas
Sorry, but doesn't make sense to me, since there is nothing parsing the result then. If you have a look at the _query() method, it does the essential parsing of the sql result, raising errors etc. I don't want to bypass the DataObject framework at this point. T Kieran.Tully AT acm.org wrote:

[PHP-DB] Having a DUH Moment with mysql_fetch_array

2005-05-09 Thread Thompson, Jimi
Ok, I'm a PHP newbie and I'm having a problem. All I want to do is parse some information out of a database and send someone and email stating that their posting has been approved. I've verified that my SQL is indeed returning the correct value for $key, but when I go to fetch the array

Re: [PHP-DB] R6025 Error

2005-05-09 Thread Ng Hwee Hwee
hi, thanks for your reply... an example of the generated HTML code is as follows: a href=odr_top.php?sort=descsortBy=T010SeqNoargmt1=argmt2=DESC/a a href=odr_top.php?sort=ascsortBy=T010SeqNoargmt1=argmt2= ASC/a i tried googling for this error but they keep telling me about some Microsoft coding

Re: [PHP-DB] Having a DUH Moment with mysql_fetch_array

2005-05-09 Thread Frank M. Kromann
Hi Jim, echo cannot display the content of an array or object. try print_r() or var_dump() - Frank Ok, I'm a PHP newbie and I'm having a problem. All I want to do is parse some information out of a database and send someone and email stating that their posting has been approved.

Re: [PHP-DB] Having a DUH Moment with mysql_fetch_array

2005-05-09 Thread Chris
Thompson, Jimi wrote: Ok, I'm a PHP newbie and I'm having a problem. All I want to do is parse some information out of a database and send someone and email stating that their posting has been approved. I've verified that my SQL is indeed returning the correct value for $key, but when I go