diff options
| author | Frank M. Kromann <fmk@php.net> | 2002-02-06 19:41:00 +0000 |
|---|---|---|
| committer | Frank M. Kromann <fmk@php.net> | 2002-02-06 19:41:00 +0000 |
| commit | 1121df7c45eb253ad197a2feab66689dde4512b7 (patch) | |
| tree | 905ff5c90cce11ef2a56d4683460e86668bc9f74 | |
| parent | d26c7a41fffc34f235dd2cd79533fc58e14297f6 (diff) | |
| download | php-git-1121df7c45eb253ad197a2feab66689dde4512b7.tar.gz | |
Added order by clause in fbsql_list_tables().
Table names will now be sorted.
| -rw-r--r-- | ext/fbsql/php_fbsql.c | 2 |
1 files changed, 1 insertions, 1 deletions
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; |