   #PHP Manual MySQL Functions mysql_real_escape_string mysql_select_db

   PHP Manual
   Prev  Next
   ______________________________________________________________________

                                 mysql_result

   (PHP 3, PHP 4 )
   mysql_result -- Get result data

Description

   mixed mysql_result ( resource result, int row [, mixed field])

   mysql_result() returns the contents of one cell from a MySQL result
   set. The field argument can be the field's offset, or the field's
   name, or the field's table dot field name (tablename.fieldname). If
   the column name has been aliased ('select foo as bar from...'), use
   the alias instead of the column name.

   When working on large result sets, you should consider using one of
   the functions that fetch an entire row (specified below). As these
   functions return the contents of multiple cells in one function call,
   they're MUCH quicker than mysql_result(). Also, note that specifying a
   numeric offset for the field argument is much quicker than specifying
   a fieldname or tablename.fieldname argument.

   Calls to mysql_result() should not be mixed with calls to other
   functions that deal with the result set.

   Example 1. mysql_result() example
   <?php
       $link = mysql_connect("localhost", "mysql_user", "mysql_password")
               or die("Could not connect: " . mysql_error());
       $result = mysql_query("SELECT name FROM work.employee")
               or die("Could not query:" . mysql_error());

       echo mysql_result($result, 2); // outputs third employee's name

       mysql_close($link);
   ?>

   Recommended high-performance alternatives : mysql_fetch_row(),
   mysql_fetch_array(), mysql_fetch_assoc() and mysql_fetch_object().
   ______________________________________________________________________

   Prev                     Home            Next
   mysql_real_escape_string  Up  mysql_select_db
