php - 如何在PHP中按升序排列下表

Question

我无法按升序排列输出表 ORDER BY ASC 不能显示表格但可以处理表格元素
我的代码如下:

<?php  
 $result = mysql_query("SHOW TABLES FROM st_db_1");
 while($row = mysql_fetch_row($result) ) {
     $result_tb = mysql_query("SELECT id FROM $row[0] LIMIT 1");
     $row_tb=mysql_fetch_array($result_tb);

     //checking for availbility of result_tb
     if (!$result_tb) {
              echo "DB Error, could not list tables\n";
              echo 'MySQL Error: ' . mysql_error();
              exit;
     }
     echo "<a href=exa.php?id=$row_tb[id]>{$row[0]}<br/><a/>" ;
 }
 mysql_free_result($result);
 mysql_free_result($result_tb);
?>

Answer 1

select  TABLE_NAME
from    information_schema.TABLE_CONSTRAINTS
order by TABLE_NAME ASC;

对 table_names 进行排序。

请参阅(在页面底部):http://bugs.mysql.com/bug.php?id=14473