   #PHP Manual MySQL Functions mysql_fetch_lengths mysql_fetch_row

   PHP Manual
   Prev  Next
   ______________________________________________________________________

                              mysql_fetch_object

   (PHP 3, PHP 4 )
   mysql_fetch_object -- Fetch a result row as an object

Description

   object mysql_fetch_object ( resource result)

   Returns an object with properties that correspond to the fetched row,
   or FALSE if there are no more rows.

   mysql_fetch_object() is similar to mysql_fetch_array(), with one
   difference - an object is returned, instead of an array. Indirectly,
   that means that you can only access the data by the field names, and
   not by their offsets (numbers are illegal property names).

     Note: Field names returned by this function are case-sensitive.

   <?php
   /* this is valid */
   echo $row->field;
   /* this is invalid */
   echo $row->0;
   ?>

   Speed-wise, the function is identical to mysql_fetch_array(), and
   almost as quick as mysql_fetch_row() (the difference is
   insignificant).

   Example 1. mysql_fetch_object() example
   <?php
   mysql_connect("hostname", "user", "password");
   mysql_select_db("mydb");
   $result = mysql_query("select * from mytable");
   while ($row = mysql_fetch_object($result)) {
       echo $row->user_id;
       echo $row->fullname;
   }
   mysql_free_result($result);
   ?>

   See also mysql_fetch_array(), mysql_fetch_assoc() and
   mysql_fetch_row().
   ______________________________________________________________________

   Prev                Home            Next
   mysql_fetch_lengths  Up  mysql_fetch_row
