Concat database results

I'm new at PHP, so if there's some kind of advice, it will be well received.

I want to concat all the results I get from a sql query to my database.

I got the line:

SELECT index FROM PlayerDeck;

NOTE: index is an integer

And now I want a variable with this output:

"1 2 3 4 5 6 7 8 9 10"