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 will set each field value equal to the field name.
Dan
> > 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'.
>
--
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]
