Select From Rdb$fields

[searain]

Hi, I need to do a select from the system tables, such as RDB$FIELDS (I am using Interbase.)

The sql is:

select RDB$FIELD_LENGTH from RDB$fields where RDB$FIELD_NAME='CATEGORY_NAME'

It is running well in the Database Management Interface. But in php, then the table name with $ got the php confused. I used the escape character. not working.

Help please.

$sql_select_domain="select RDB$FIELD_LENGTH from RDB$fields where RDB$FIELD_NAME='CATEGORY_NAME'";

$select_domain_category_name=ibase_query($dbconn, $sql_select_domain);

$domain_category_name_row=ibase_fetch_object($select_domain_category_name);

$category_name_length=$domain_category_name_row->RDB$FIELD_LENGTH;

[searain]

sorry, my error, escape character will work here. i made some errors in some other places.