Re: Sorting an array
| From: | Jim Lucas | Date: | Tue, 01 Mar 2011 16:03:14 +0000 |
| Subject: | Re: Sorting an array | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-311607@lists.php.net to get a copy of this message | ||
On 2/28/2011 7:52 PM, Ron Piggott wrote:
>
> I need help to know how to sort the words / phrases in my array.
>
> Variable name: $words_used
> print_r( $words_used ); Current output: Array ( [187] => Sin [249] => Punished [98] =>
> Sanctuary [596] => Sing [362] => Anointing Oil )
> Desired result: Alphabetical sort: Array ( [362] => Anointing Oil [249] => Punished [98]
> => Sanctuary [187] => Sin [596] => Sing )
>
> The #’s are the auto_increment value of the word in the mySQL database. The number is not
> representative of alphabetical order, but the order it was added to the database.
>
> Thank you for your assistance.
>
> Ron
>
> The Verse of the Day
> “Encouragement from God’s Word”
> http://www.TheVerseOfTheDay.info
>
Besides the answer others have pointed you to, I would recommend doing it in mysql?
SELECT * FROM <table> ORDER BY <your_column>;
Check out the syntax for it here.
http://dev.mysql.com/doc/refman/5.0/en/select.html
and
http://dev.mysql.com/doc/refman/5.0/en/order-by-optimization.html
Jim Lucas