I’m trying to display an array of href links as a string with the results separated by commas so as to display:-
[I Am The Walrus, [URL="http:///song/55/hello-goodbye"]Hello, Goodbye, [URL="http:///song/56/the-fool-on-the-hill"]The Fool On The Hill, [URL="http:///song/57/magical-mystery-tour"]Magical Mystery Tour, [URL="http:///song/58/lady-madonna"]Lady Madonna](http:///song/54/i-am-the-walrus)
(NB: Some results will contain commas (Hello, Goodbye) so I’ll need to use the 'implode' function rather than 'preg_replace').
The links are comprised of three different values from each result, i.e. 'id' and 'url' for the URL and 'name' for the name to be displayed.
My current code:
while ($row = mysqli_fetch_array($result)) //Creates array.
$songs = array('id' => $row['id'], 'url' => $row['url'], 'name' => $row['name']);
<?php foreach ($songs as $song)
$song = '<a href="/song/' . $song['id'] . '/' . $song['url'] . '">' . $song['name'] . '</a>';
echo implode(", ", $songs);
Notice: Array to string conversion in C:\...
Notice is repeated x 5 times (i.e. however many results there are)
Followed by the below:-
Array, Array, Array, Array, Array
Again, repeated according to number of results.
The method was taken from this problem: PHP Separate comma list with links, but it only requires the one value to create the link; mine needs three.
I feel all I require to make this work is a minor tweak but I just can’t figure it out – any suggestions?