>Each row can have up to 16 pictures per item seperated by commas.
That's a poor database design decision. Each row should only contain one url. Use another table to store multiple rows of image location data for each item.
As an alternative, you could probably achieve what you want using the PHP explode function, but you would need to code that by hand. But I would suggest fixing the database design instead.
OK I will try that. That is how the data was imported to me in a spreadsheet. There should be an efficient way to open the spreadsheet and put the image urls in their own rows, cause it is to much data to do it maunally.
I am assuming that the list of URLs shown is only a partial and there are many more in multiple cells in the spreadsheet. One possible way to convert from SS is to copy the SS cells containing the URLs to a word processor (it should come into the WP as a table), convert the table to text, using a 'replace all', change the .jpg, (.jpg<comma>) with .jpg<paragraph mark>; this will result in a column of URLs. Copy (or import) the column of URLs into a table in your DB. Don't forget you'll need a field in this database linking each URL to it's corresponding record in the main table.
I ending up using Excel, Text-to-Column feature under the Data Tab. Thanks.