   #PHP Manual SESAM database functions sesam_execimm sesam_fetch_result

   PHP Manual
   Prev  Next
   ______________________________________________________________________

                               sesam_fetch_array

   (PHP 3 CVS only)
   sesam_fetch_array -- Fetch one row as an associative array

Description

   array sesam_fetch_array ( string result_id [, int whence [, int
   offset]])

   Returns an array that corresponds to the fetched row, or FALSE if
   there are no more rows.

   sesam_fetch_array() is an alternative version of sesam_fetch_row().
   Instead of storing the data in the numeric indices of the result
   array, it stores the data in associative indices, using the field
   names as keys.

   result_id is a valid result id returned by sesam_query() (select type
   queries only!).

   For the valid values of the optional whenceand offset parameters, see
   the sesam_fetch_row() function for details.

   sesam_fetch_array() fetches one row of data from the result associated
   with the specified result identifier. The row is returned as an
   associative array. Each result column is stored with an associative
   index equal to its column (aka. field) name. The column names are
   converted to lower case.

   Columns without a field name (e.g., results of arithmetic operations)
   and empty fields are not stored in the array. Also, if two or more
   columns of the result have the same column names, the later column
   will take precedence. In this situation, either call sesam_fetch_row()
   or make an alias for the column.

   SELECT TBL1.COL AS FOO, TBL2.COL AS BAR FROM TBL1, TBL2

   A special handling allows fetching "multiple field" columns (which
   would otherwise all have the same column names). For each column of a
   "multiple field", the index name is constructed by appending the
   string "(n)" where n is the sub-index of the multiple field column,
   ranging from 1 to its declared repetition factor. The indices are NOT
   zero based, in order to match the nomenclature used in the respective
   query syntax. For a column declared as:

   CREATE TABLE ... ( ... MULTI(3) INT )

   the associative indices used for the individual "multiple field"
   columns would be "multi(1)", "multi(2)", and "multi(3)" respectively.

   Subsequent calls to sesam_fetch_array() would return the next (or
   prior, or n'th next/prior, depending on the scroll attributes) row in
   the result set, or FALSE if there are no more rows.

   Example 1. SESAM fetch array
   <?php
   $result = sesam_query("SELECT * FROM phone\n" .
                          "  WHERE LASTNAME='" . strtoupper($name) .
   "'\n".
                          "  ORDER BY FIRSTNAME", 1);
   if (!$result) {
       /* ... error ... */
   }
   // print the table:
   echo "<table border=\"1\">\n";
   while (($row = sesam_fetch_array($result)) && count($row) > 0) {
       echo "<tr>\n";
       echo "<td>" . htmlspecialchars($row["firstname"]) . "</td>\n";
       echo "<td>" . htmlspecialchars($row["lastname"]) . "</td>\n";
       echo "<td>" . htmlspecialchars($row["phoneno"]) . "</td>\n";
       echo "</tr>\n";
   }
   echo "</table>\n";
   sesam_free_result($result);
   ?>

   See also: sesam_fetch_row() which returns an indexed array.
   ______________________________________________________________________

   Prev          Home               Next
   sesam_execimm  Up  sesam_fetch_result
