PHP mysql_field_name() Function

Complete PHP MySQL Reference

Definition and Usage

The mysql_field_name() function returns the name of a field in a recordset.

Returns the field name on success, or FALSE on failure.

Syntax

mysql_field_name(data,field_offset)

Example

<?php
$con = mysql_connect("localhost", "peter", "abc123");
if (!$con)
  {
  die('Could not connect: ' . mysql_error());
  }

$db_selected = mysql_select_db("test_db",$con);

$sql = "SELECT * from Person";
$result = mysql_query($sql,$con);

$name = mysql_field_name($result, 0);

echo $name;

mysql_close($con);
?>

The output of the code above could be:

LastName

Complete PHP MySQL Reference

Jump to: Top of Page or HOME or Printer friendly page

W3Schools provides material for training only. We do not warrant the correctness of its contents. The risk from using it lies entirely with the user. While using this site, you agree to have read and accepted our terms of use and privacy policy.

Copyright 1999-2008 by Refsnes Data. All Rights Reserved.

W3Schools was converted to XHTML in December 1999