I create a table in PHP and next to create the index for it . But the create index statment can't work in PHP. It can work in ISQL . It's a bug in PHP? The program like that: $sql = "CREATE TABLE $table_name (id integer ,name char(20))"; $ibase_query($conn,$sql); $sql = "CREATE INDEX $table_index_name on $table_name (id)"; $ibase_query($conn,$sql); the first part can work , but the second can't. -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]