Re: Sorting a PHP array

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 should just search for a manual on this, but could anybody give me
> a quick start?
>
>
>
> Thanks,
>
>
>
> Charlie
>
>

Sure you can sort this array, but you'd have to write your own I think. 
  Why not just order a query and use those results instead of an array?

A query should process pretty fast on almost any system.  Are you in 
need of such instantaneous response that you thought of going to an array?

You could have this query:

$q = "select author,title,year,media ... from books_table order by 
'$sortkey'"

where $sortkey can be a desired field name chosen by the user.  Could be 
a multi-fieldname sortkey as well.  Could be run as an ajax request if 
need be too.

So many better ways of doing this than an array IMHO.

-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php