<HTML ><HEAD ><TITLE >ingres_fetch_array</TITLE ><META NAME="GENERATOR" CONTENT="Modular DocBook HTML Stylesheet Version 1.7"><LINK REL="HOME" TITLE="PHP Manual" HREF="index.html"><LINK REL="UP" TITLE="Ingres II functions" HREF="ref.ingres.html"><LINK REL="PREVIOUS" TITLE="ingres_connect" HREF="function.ingres-connect.html"><LINK REL="NEXT" TITLE="ingres_fetch_object" HREF="function.ingres-fetch-object.html"><META HTTP-EQUIV="Content-type" CONTENT="text/html; charset=ISO-8859-1"></HEAD ><BODY CLASS="refentry" BGCOLOR="#FFFFFF" TEXT="#000000" LINK="#0000FF" VLINK="#840084" ALINK="#0000FF" ><DIV CLASS="NAVHEADER" ><TABLE SUMMARY="Header navigation table" WIDTH="100%" BORDER="0" CELLPADDING="0" CELLSPACING="0" ><TR ><TH COLSPAN="3" ALIGN="center" >PHP Manual</TH ></TR ><TR ><TD WIDTH="10%" ALIGN="left" VALIGN="bottom" ><A HREF="function.ingres-connect.html" ACCESSKEY="P" >Prev</A ></TD ><TD WIDTH="80%" ALIGN="center" VALIGN="bottom" ></TD ><TD WIDTH="10%" ALIGN="right" VALIGN="bottom" ><A HREF="function.ingres-fetch-object.html" ACCESSKEY="N" >Next</A ></TD ></TR ></TABLE ><HR ALIGN="LEFT" WIDTH="100%"></DIV ><H1 ><A NAME="function.ingres-fetch-array" ></A >ingres_fetch_array</H1 ><DIV CLASS="refnamediv" ><A NAME="AEN41162" ></A ><P > (PHP 4 >= 4.0.2)</P >ingres_fetch_array -- Fetch a row of result into an array</DIV ><DIV CLASS="refsect1" ><A NAME="AEN41165" ></A ><H2 >Description</H2 >array <B CLASS="methodname" >ingres_fetch_array</B > ( [int result_type [, resource link]])<BR ></BR ><DIV CLASS="warning" ><P ></P ><TABLE CLASS="warning" BORDER="1" WIDTH="100%" ><TR ><TD ALIGN="CENTER" ><B >Warning</B ></TD ></TR ><TR ><TD ALIGN="LEFT" ><P >This function is <SPAN CLASS="emphasis" ><I CLASS="emphasis" >EXPERIMENTAL</I ></SPAN >. The behaviour of this function, the name of this function, and anything else documented about this function may change without notice in a future release of PHP. Use this function at your own risk.</P ></TD ></TR ></TABLE ></DIV ><P > <B CLASS="function" >ingres_fetch_array()</B > Returns an array that corresponds to the fetched row, or <TT CLASS="constant" ><B >FALSE</B ></TT > if there are no more rows. </P ><P > This function is an extended version of <A HREF="function.ingres-fetch-row.html" ><B CLASS="function" >ingres_fetch_row()</B ></A >. In addition to storing the data in the numeric indices of the result array, it also stores the data in associative indices, using the field names as keys. </P ><P > If two or more columns of the result have the same field names, the last column will take precedence. To access the other column(s) of the same name, you must use the numeric index of the column or make an alias for the column. <DIV CLASS="informalexample" ><A NAME="AEN41185" ></A ><P ></P ><TABLE BORDER="0" BGCOLOR="#E0E0E0" CELLPADDING="5" ><TR ><TD ><PRE CLASS="programlisting" >ingres_query(select t1.f1 as foo t2.f1 as bar from t1, t2); $result = ingres_fetch_array(); $foo = $result["foo"]; $bar = $result["bar"];</PRE ></TD ></TR ></TABLE ><P ></P ></DIV > </P ><P > <TT CLASS="parameter" ><I >result_type</I ></TT > can be INGRES_NUM for enumerated array, INGRES_ASSOC for associative array, or INGRES_BOTH (default). </P ><P > Speed-wise, the function is identical to <A HREF="function.ingres-fetch-object.html" ><B CLASS="function" >ingres_fetch_object()</B ></A >, and almost as quick as <A HREF="function.ingres-fetch-row.html" ><B CLASS="function" >ingres_fetch_row()</B ></A > (the difference is insignificant). </P ><P > <TABLE WIDTH="100%" BORDER="0" CELLPADDING="0" CELLSPACING="0" CLASS="EXAMPLE" ><TR ><TD ><DIV CLASS="example" ><A NAME="AEN41193" ></A ><P ><B >Example 1. <B CLASS="function" >ingres_fetch_array()</B > example</B ></P ><TABLE BORDER="0" BGCOLOR="#E0E0E0" CELLPADDING="5" ><TR ><TD ><PRE CLASS="php" ><?php ingres_connect ($database, $user, $password); ingres_query ("select * from table"); while ($row = ingres_fetch_array()) { echo $row["user_id"]; # using associative array echo $row["fullname"]; echo $row[1]; # using enumerated array echo $row[2]; } ?></PRE ></TD ></TR ></TABLE ></DIV ></TD ></TR ></TABLE > </P ><P > See also <A HREF="function.ingres-query.html" ><B CLASS="function" >ingres_query()</B ></A >, <A HREF="function.ingres-num-fields.html" ><B CLASS="function" >ingres_num_fields()</B ></A >, <A HREF="function.ingres-field-name.html" ><B CLASS="function" >ingres_field_name()</B ></A >, <A HREF="function.ingres-fetch-object.html" ><B CLASS="function" >ingres_fetch_object()</B ></A >, and <A HREF="function.ingres-fetch-row.html" ><B CLASS="function" >ingres_fetch_row()</B ></A >. </P ></DIV ><DIV CLASS="NAVFOOTER" ><HR ALIGN="LEFT" WIDTH="100%"><TABLE SUMMARY="Footer navigation table" WIDTH="100%" BORDER="0" CELLPADDING="0" CELLSPACING="0" ><TR ><TD WIDTH="33%" ALIGN="left" VALIGN="top" ><A HREF="function.ingres-connect.html" ACCESSKEY="P" >Prev</A ></TD ><TD WIDTH="34%" ALIGN="center" VALIGN="top" ><A HREF="index.html" ACCESSKEY="H" >Home</A ></TD ><TD WIDTH="33%" ALIGN="right" VALIGN="top" ><A HREF="function.ingres-fetch-object.html" ACCESSKEY="N" >Next</A ></TD ></TR ><TR ><TD WIDTH="33%" ALIGN="left" VALIGN="top" >ingres_connect</TD ><TD WIDTH="34%" ALIGN="center" VALIGN="top" ><A HREF="ref.ingres.html" ACCESSKEY="U" >Up</A ></TD ><TD WIDTH="33%" ALIGN="right" VALIGN="top" >ingres_fetch_object</TD ></TR ></TABLE ></DIV ></BODY ></HTML >