PHP Mysql Tutorials, Function, mysql_field_table()

Licensed Scripts

Licensed Scripts

HTML Tutorials	CSS Tutorials
Photoshop Tutorials	Flash Tutorials
JavaScript Tutorials	Jquery Tutorials
JSP Topics	Php Tutorials
MYSQL Tutorials	Regular Expression
Perl Tutorial	Domain & Dns
Unix Commands	C++
Vista Services	Linux Services
Web Building	Seo Tutorial
Powerpoint	VB.Net Tutorial
Rss Feed	GIMP

Clipart Pictures

Signs

Country Emblems

Background Images

Logos

Menu Builder	Button Creator
Link Analyzer	DNS Lookup
Website Popularity	Color Chooser
Apache Ver Lookup	Page Rank Checker
Case Converter	Form Generator
Statistics	Epoch-GMT Converter
Hours Calculator	Htpasswd Generator
Favicon Generator	Backlink Checker
Image Crop Tool	Chart and Graph Tools
Multiple Drop Down Menu	Email Verification Tool
If Modified Since	Language Subtags
FBLike Count Calculator	SEO Text Browser

PHP Tutorial

Portuguese

Outsource Servers

Online Calculator

Hosting Companies

Home

Home

Scripts

Scripts

Tutorials

Tutorials

Images

Images

Tools

Tools

Purchase

Purchase

Snippets

Snippets

PHP Topics

Data Types

Operators

Control Structures

Functions

Pre-defined Function

Calendar Functions

Date and Time

Array Functions

Array Functions List1

Array Functions List2

Math Functions

PHP Mysql Functions

File Handling

Error Handling

PHP Mail

String Functions

String Functions List1

String Functions List2

Session Functions

Cookies Functions

Form Variables

Running PHP from JS

Ask Your Doubts

track, manage link submission status

mysql_field_table Function in PHP

Tutorials »Php »

Topic

What is mysql_field_table() function in PHP?
How does mysql_field_table works?

Explanation

mysql_field_table() function returns the table name of specified field in the result set.

Syntax

string mysql_field_table ( resource result, int field_offset)

Returns the table name of a specified field name on success, or FALSE on failure

mysql_field_table() function returns the name of the table where a specified field is located. Field can be specified by passing result set returned by mysql_query() and field index. mysql_field_table() function find and returns table name of field specified by the field index. Field index value starts from '0'.

Example:

<?php

// Attempt to connect to the default database server

$link = mysql_connect("mysql_host", "mysql_user", "mysql_password")
or die ("Could not connect");

//select database

$db_select = mysql_selectdb("mydb",$link);

//returns result set on executing the query

$result=mysql_query("select * from content",$link);

//Find and returns the table name of specified field

$table = mysql_field_table($result, 1);
echo "Table Name of specified field: $table";

mysql_close($link);

?>

RESULT:

Table Name of specified field: Content

Other Links

web hosting