mysql - PHP: Warning: sort() expects parameter 1 to be array, resource given

Question

I wanted to arrange the array of table list with sort() function but i am getting same kind of warning my code as follows :

 <?PHP 
     require_once("lib/connection.php"); 

     $result = mysql_query("SHOW TABLES FROM `st_db_1`");

     sort($result);
     foreach ($result as $result){
     echo $result ;
     } 
 ?>

and the warning i am getting are :

Warning: sort() expects parameter 1 to be array, resource given in C:wampwwwCopy (4)       of st_db_1est_2.php on line 9
Warning: Invalid argument supplied for foreach() in C:wampwwwCopy (4) of st_db_1est_2.php on line 10

Answer 1

The warning is pretty clear: mysql_query does not return an array with results from the query, but a resource. You need a function like mysql_fetch_array() to return the data you need (and on which you can perform a sort operation).

See the manual for the use of mysql_query() http://nl3.php.net/mysql_query

And maybe unrelated, but you can sort your results in MySQL right away by adding ORDER BY <fieldname> to your query.