Justtechjobs.com Find a programming school near you






Online Campus Both


php-db | 2001062

Re: [PHP-DB] Informix Question how to put data from query into variables From: Christian Haul (haul <email protected>)
Date: 06/21/01

"wflow" <william <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'.

>  <email protected>($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: php-db-unsubscribe <email protected>
For additional commands, e-mail: php-db-help <email protected>
To contact the list administrators, e-mail: php-list-admin <email protected>