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
have in mind
: Thursday, June 21, 2001 10:23 PM
Subject: Re: [PHP-DB] Informix Question (Still need help,please)
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
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 array.
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 array.
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
-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'm having trouble with newlines in
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 newlines or
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:
I a do
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