Hi,

Have a try with something like this. Not tested and it's Friday ;o)

$connid = ifx_connect(blah,blah,blah) or
                  die("An error occurred connecting to database");

$Query = "SELECT tracknum,orderdate,ordertotal,status,shipdate ".
                "FROM orders ".
                "WHERE tracknum = '$trknum' ";

$rid = ifx_query($Query, $connid, IFX_SCROLL) or
             die("An error occurred querying database");

$row = ifx_fetch_row($rid, "NEXT");

$orderdate = $row['orderdate'];

$Query = "SELECT stuff ".
                "FROM somewhere ".
                "WHERE orderdate = '$orderdate' ";


$rid = ifx_query($Query, $connid, IFX_SCROLL) or
             die("An error occurred querying database");

@ifx_htmltbl_result($rid,"border=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)


> 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 would not have
to
> even post this question.
>
> I only did post the question, because I needed help and figured I would
ask
> the experts, but all I got was somebody who says "rtfm" and most likely
did
> not read or understand my question, so, thanks a lot.
>
>
>
> B
>
> "Christian Haul" <[EMAIL PROTECTED]> wrote in message
> 9gsg0u$6nf$[EMAIL PROTECTED]">news:9gsg0u$6nf$[EMAIL PROTECTED]...
> > "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 a select tracknum,orderdate,ordertotal,status,shipdate from
> orders
> > > where tracknum = '$trknum' and I want the data returned into vars:
like
> > > orderdate = $orderdate so I can create a new query like: select * from
> > > shipping where orderdate = '$orderdate'.
> >
> > > @ifx_htmltbl_result($sql_result,"border=1");
> >
> > You might want to consider reading the php manual, especially the part
on
> functions
> > and even more the one on informix functions. There you'll find a
function
> > called ifx_fetch_row.
> >
> > Chris.
> >
> > --
> > PHP Database Mailing List (http://www.php.net/)
> > To unsubscribe, e-mail: [EMAIL PROTECTED]
> > For additional commands, e-mail: [EMAIL PROTECTED]
> > To contact the list administrators, e-mail: [EMAIL PROTECTED]
> >
>
>
>
> --
> PHP Database Mailing List (http://www.php.net/)
> To unsubscribe, e-mail: [EMAIL PROTECTED]
> For additional commands, e-mail: [EMAIL PROTECTED]
> To contact the list administrators, e-mail: [EMAIL PROTECTED]
>
>


-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]

Reply via email to