[PHP-DB] Sorting a PHP array

2013-05-15 Thread Charlie Lewis
I have a bookseller database list read into a PHP array with dimensions [row][field]. There are 32 fields in each record/row and up to 500 records. What is the neatest way to sort the array by any of the fields, such as author or title? I know I should just search for a manual on this, but

Re: [PHP-DB] Sorting a PHP array

2013-05-15 Thread Matt Pelmear
I would use ORDER BY in your query and let the database do the work, assuming you're using a standard relational database (like MySQL or Postgresql). Otherwise, if you MUST do it in PHP, you could look at usort(), or uasort() using your own custom sorting function. I would, however,

[PHP-DB] Re: Sorting a PHP array

2013-05-15 Thread Jim Giner
On 5/15/2013 12:32 PM, Charlie Lewis wrote: I have a bookseller database list read into a PHP array with dimensions [row][field]. There are 32 fields in each record/row and up to 500 records. What is the neatest way to sort the array by any of the fields, such as author or title? I know I

Re: [PHP-DB] Sorting a PHP array

2013-05-15 Thread Bastien
Bastien Koert On 2013-05-15, at 12:32 PM, Charlie Lewis charlie.le...@honest-it.com wrote: I have a bookseller database list read into a PHP array with dimensions [row][field]. There are 32 fields in each record/row and up to 500 records. What is the neatest way to sort the array by