RE: [PHP-DB] Informix question

2001-06-22 Thread Mark Roedel
> -Original Message- > From: Bård Farstad [mailto:[EMAIL PROTECTED]] > Sent: Tuesday, June 19, 2001 11:45 AM > To: [EMAIL PROTECTED] > Subject: [PHP-DB] Informix question > > > I'm writing an application which uses the PHP interface to > informix. I&#

Re: [PHP-DB] Informix Question (Still need help,please)

2001-06-22 Thread Dan Fitzpatrick
B, Do your first query, then run this (for one record returned). while($row = ifx_fetch_row($query_result_id)) { for(reset($row); $fieldname=key($row); next($row)) { $$fieldname = $row[$fieldname]; } } Do your second query. The while statement w

Re: [PHP-DB] Informix Question (Still need help,please)

2001-06-22 Thread Christian Haul
On 21.Jun.2001 -- 02:22 PM, William Flow wrote: > Chris, >Thanks for the advice, of course I already did "rtfm" and the > ifx_fetch_rows entry did not really help me. It, in fact > does NOT return an enumerated array, as the top line of the page > states. It ONLY returns an associative

Re: [PHP-DB] Informix Question (Still need help,please)

2001-06-22 Thread Christian Haul
On 21.Jun.2001 -- 02:22 PM, William Flow wrote: > Chris, >Thanks for the advice, of course I already did "rtfm" and the > ifx_fetch_rows entry did not really help me. It, in fact > does NOT return an enumerated array, as the top line of the page > states. It ONLY returns an associative

Re: [PHP-DB] Informix Question (Still need help,please)

2001-06-22 Thread Paul Gardiner
der=1"); ifx_free_result ($rid); ifx_close($connid); Regards, - Paul - ----- Original Message - From: "wflow" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Thursday, June 21, 2001 10:23 PM Subject: Re: [PHP-DB] Informix Question (Still need help,please) > C

Re: [PHP-DB] Informix Question (Still need help,please)

2001-06-22 Thread Paul Burney
on 6/21/01 2:23 PM, wflow at [EMAIL PROTECTED] wrote: >>> What I want to do is create another query from some of the data from another >>> one. The question is how do I take the data I get back from my first query >>> and put that into variables so I can build my second query. The example I >>> h

Re: [PHP-DB] Informix Question (Still need help,please)

2001-06-21 Thread wflow
Chris, Thanks for the advice, of course I already did "rtfm" and the ifx_fetch_rows entry did not really help me. It, in fact does NOT return an enumerated array, as the top line of the page states. It ONLY returns an associative array. If there was an ifx_fetch_array like the one for MySQL, I w

Re: [PHP-DB] Informix Question how to put data from query into variables

2001-06-21 Thread Christian Haul
"wflow" <[EMAIL PROTECTED]> wrote: > Hi All, > What I want to do is create another query from some of the data from another > one. The question is how do I take the data I get back from my first query > and put that into variables so I can build my second query. The example I > have in mind is:

Re: [PHP-DB] Informix question

2001-06-21 Thread Christian Haul
Bård Farstad <[EMAIL PROTECTED]> wrote: > Hi all, > I'm writing an application which uses the PHP interface to informix. I'm > having trouble with newlines in char/varchar or lvarchar fields. > How can I store newlines (\n) to an informix database without using blobs? You need to escape newlin

[PHP-DB] Informix Question how to put data from query into variables

2001-06-20 Thread wflow
Hi All, What I want to do is create another query from some of the data from another one. The question is how do I take the data I get back from my first query and put that into variables so I can build my second query. The example I have in mind is: I a do a select tracknum,orderdate,ordertotal

[PHP-DB] Informix question

2001-06-19 Thread Bård Farstad
Hi all, I'm writing an application which uses the PHP interface to informix. I'm having trouble with newlines in char/varchar or lvarchar fields. How can I store newlines (\n) to an informix database without using blobs? I'm using: -- Bård Farstad Systems developer ez.no | developer.ez.no |