Microsoft Word - Core PHP Programming Using PHP to Build Dynamic Web Sites

$Result = msql_query($Query, $Link);

print("Field 0 is ". msql_fieldname($Result, 0));

msql_close($Link);
?>

string msql_fieldtable(integer result, integer field)

The msql_fieldtable function returns the name of the table for the specified field.

<?
$Link = msql_connect("msql.clearink.com");
msql_select_db("store", $Link);

$Query = "SELECT * FROM item";
$Result = msql_query($Query, $Link);

print("Field 0 is from ". msql_fieldtable($Result, 0));

msql_close($Link);
?>

string msql_fieldtype(integer result, integer field)

The msql_fieldtype function returns the type of the specified field.

<?
$Link = msql_connect("msql.clearink.com");
msql_select_db("store", $Link);

$Query = "SELECT * FROM item";
$Result = msql_query($Query, $Link);

print("Field 0 is ". msql_fieldtype($Result, 0));

msql_close($Link);
?>

boolean msql_free_result(integer result)

When a script ends, all results are freed. If memory is a concern while your script is
running, use msql_free_result.