[RESOLVED] Sorting an array already created.

Beffic

So I created an array by default value in MySQL. Now I am trying to display these separately which I am figuring the sort() function would help but it's not displaying what I had in mind. Instead I get blank. I am new to arrays and anything helps. I have looked at sort() and array() tutorials but nothing includes the MySQL help like I need.

MySQL: blessing = None, None, Buy, Buy, Buy

$blessing = array($char['blessing']);
$blessing = sort($blessing);

print "$blessing[0], $blessing[1], $blessing[2]";

Any help is appreciated!

Beffic

Any suggestions? Anything helps, even let me know if I am missing a big piece.

doobster

To ensure I understand this. Is $blessing a comma separated list? If you wish to convert this to an array you'll want to use the explode() function, e.g.

$blessing = explode(',', $char['blessing']);

Also, the sort() function returns a boolean true or false if it was successful, so you don't actual want to set $blessing to it's results.

NogDog

sort() does not return an array: it sorts the specified array and the returns a boolean based on success/failure, so do not assign its result to the array variable.

Beffic

doobster;10973482 wrote:
To ensure I understand this. Is $blessing a comma separated list? If you wish to convert this to an array you'll want to use the explode() function, e.g.
$blessing = explode(',', $char['blessing']);
Also, the sort() function returns a boolean true or false if it was successful, so you don't actual want to set $blessing to it's results.

Wow, that did exactly what I wanted! thanks!