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

by

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.

More Related Contents:

  1. Comma separated numeric values – PHP CodeIgniter
  2. Using PHP data in MySQL [closed]
  3. How to sort user data by id
  4. Select those record only from table 1 where city exist against state id in table 2 in PHP
  5. PHP PDO prepared statements
  6. PDO MySQL: Use PDO::ATTR_EMULATE_PREPARES or not?
  7. select count(*) from table of mysql in php
  8. Why I am getting Cannot pass parameter 2 by reference error when I am using bindParam with a constant value?
  9. Loading .sql files from within PHP
  10. Incorrect Integer (2147483647) is inserted into MySQL?
  11. Save PHP array to MySQL?
  12. implement LIKE query in PDO
  13. How to successfully rewrite old mysql-php code with deprecated mysql_* functions?
  14. How can I use mysqli_fetch_array() twice?
  15. Executing multiple SQL queries in one statement with PHP
  16. MySQL db question marks instead of hebrew characters..?
  17. “Warning: Cannot modify header information – headers already sent by” error [duplicate]
  18. mysql_num_rows() expects parameter 1 to be resource, boolean given in [duplicate]
  19. Easy way to export a SQL table without access to the server or phpMyADMIN
  20. How can I count the numbers of rows that a MySQL query returned?
  21. How I can create installer for website. PHP mysql [closed]
  22. How to join two tables with ssp.class.php
  23. How to convert IPv6 from binary for storage in MySQL
  24. Eloquent many-to-many-to-many – how to load distant relation easily
  25. Using utf8mb4 with php and mysql
  26. how do I get month from date in mysql
  27. Strange problem with the length of the field gotten from database [duplicate]
  28. Can I detect and handle MySQL Warnings with PHP?
  29. How to write a stored procedure in phpMyAdmin?
  30. mysql count into PHP variable

Leave a Comment