From 1121df7c45eb253ad197a2feab66689dde4512b7 Mon Sep 17 00:00:00 2001 From: "Frank M. Kromann" Date: Wed, 6 Feb 2002 19:41:00 +0000 Subject: [PATCH] Added order by clause in fbsql_list_tables(). Table names will now be sorted. --- ext/fbsql/php_fbsql.c | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) diff --git a/ext/fbsql/php_fbsql.c b/ext/fbsql/php_fbsql.c index 03557034e7..75c8d11ce8 100644 --- a/ext/fbsql/php_fbsql.c +++ b/ext/fbsql/php_fbsql.c @@ -1994,7 +1994,7 @@ PHP_FUNCTION(fbsql_list_dbs) 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; -- 2.50.1