cvs: php4 /ext/fbsql php_fbsql.c

fmk Wed Feb 6 14:41:01 2002 EDT Modified files: /php4/ext/fbsql php_fbsql.c Log: Added order by clause in fbsql_list_tables(). Table names will now be sorted. Index: php4/ext/fbsql/php_fbsql.c diff -u php4/ext/fbsql/php_fbsql.c:1.72 php4/ext/fbsql/php_fbsql.c:1.73 --- php4/ext/fbsql/php_fbsql.c:1.72 Wed Feb 6 14:24:02 2002 +++ php4/ext/fbsql/php_fbsql.c Wed Feb 6 14:41:00 2002 @@ -16,7 +16,7 @@ +----------------------------------------------------------------------+ */ -/* $Id: php_fbsql.c,v 1.72 2002/02/06 19:24:02 fmk Exp $ */ +/* $Id: php_fbsql.c,v 1.73 2002/02/06 19:41:00 fmk Exp $ */ /* TODO: * @@ -1994,7 +1994,7 @@ Retreive a list of all tables from the specifoied database */ PHP_FUNCTION(fbsql_list_tables) { - char* sql = "select t0.\"table_name\"from information_schema.tables t0, information_schema.SCHEMATA t1 where t0.schema_pk = t1.schema_pk and t1.\"schema_name\" = current_schema;"; + char* sql = "select t0.\"table_name\"from information_schema.tables t0, information_schema.SCHEMATA t1 where t0.schema_pk = t1.schema_pk and t1.\"schema_name\" = current_schema order by \"table_name\";"; PHPFBLink* phpLink = NULL; zval **fbsql_link_index = NULL, **database_name; int id;