<HTML ><HEAD ><TITLE >ingres_fetch_array</TITLE ><META NAME="GENERATOR" CONTENT="Modular DocBook HTML Stylesheet Version 1.7"><LINK REL="HOME" TITLE="Manual de PHP" 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" >Manual de PHP</TH ></TR ><TR ><TD WIDTH="10%" ALIGN="left" VALIGN="bottom" ><A HREF="function.ingres-connect.html" ACCESSKEY="P" >Anterior</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" >Siguiente</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="AEN32158" ></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="AEN32161" ></A ><H2 >Description</H2 >array <B CLASS="methodname" >ingres_fetch_array</B > ( [int result_type [, resource link]])<BR ></BR ><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="AEN32178" ></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 II_NUM for enumerated array, II_ASSOC for associative array, or II_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="AEN32186" ></A ><P ><B >Ejemplo 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" >Anterior</A ></TD ><TD WIDTH="34%" ALIGN="center" VALIGN="top" ><A HREF="index.html" ACCESSKEY="H" >Inicio</A ></TD ><TD WIDTH="33%" ALIGN="right" VALIGN="top" ><A HREF="function.ingres-fetch-object.html" ACCESSKEY="N" >Siguiente</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" >Subir</A ></TD ><TD WIDTH="33%" ALIGN="right" VALIGN="top" >ingres_fetch_object</TD ></TR ></TABLE ></DIV ></BODY ></HTML >