print($row_array[0]. "
\n");
}
msql_close($Link);
?>
integer msql_list_tables(string database, integer link)
The msql_list_tables function returns a result identifier as if the database were
queried with msql_query. Any of the functions for fetching rows or fields may be used to
get the names of the fields. The link argument is optional. If left out, the last-opened
connection will be used.
<?
$Link = msql_connect("msql.clearink.com");
msql_select_db("store", $Link);
$Result = msql_list_tables("store", $Link);
while($row_array = msql_fetch_row($Result))
{
print($row_array[0]. "
\n");
}
msql_close($Link);
?>
integer msql_num_fields(integer result)
Use msql_num_fields to get the number of fields in a result set.
<?
$Link = msql_connect("msql.clearink.com");
msql_select_db("store", $Link);
$Query = "SELECT * FROM item i, SKU s ";
$Query .= "WHERE i.SKU = s.ID ";
$Result = msql_query($Query, $Link);
print(msql_num_fields($Result));
msql_close($Link);
?>
integer msql_num_rows(integer result)