Re: 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" <haul@informatik.tu-darmstadt.de> wrote in message news:9gsg0u$6nf$2@w153.z064000151.sjc-ca.dsl.cnc.net... > "wflow" <william@photorola.com> 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: php-db-unsubscribe@lists.php.net > For additional commands, e-mail: php-db-help@lists.php.net > To contact the list administrators, e-mail: php-list-admin@lists.php.net >