(PHP 4 >= 4.0.6, PHP 5)
fbsql_list_fields — List FrontBase result fields
$database_name
, string $table_name
[, resource $link_identifier
] )Retrieves information about the given table.
database_nameThe database name.
table_nameThe table name.
link_identifierA FrontBase link identifier returned by fbsql_connect() or fbsql_pconnect().
If optional and not specified, the function will try to find an open link to the FrontBase server and if no such link is found it will try to create one as if fbsql_connect() was called with no arguments.
Returns a result pointer which can be used with the
fbsql_field_xxx functions, or FALSE on error.
A string describing the error will be placed in $phperrmsg, and unless the function was called as @fbsql() then this error string will also be printed out.
Example #1 fbsql_list_fields() example
<?php
$link = fbsql_connect('localhost', 'myname', 'secret');
$fields = fbsql_list_fields("database1", "table1", $link);
$columns = fbsql_num_fields($fields);
for ($i = 0; $i < $columns; $i++) {
echo fbsql_field_name($fields, $i) . "\n";;
}
?>
The above example will output something similar to:
field1 field2 field3 ...