Manipulating php/mySQL output

[frank5050]

Hi,

Given below is the output of a field from a mySQL/php query:

Product ID: 8457, Product Qty: 3, Product SKU: M-242, Product Name: DCE/DTE DB60 Crossover Cable - 1FT, Product Weight: 1, Product Variation Details: , Product Unit Price: 4.68, Product Total Price: 14.04|Product ID: 8800, Product Qty: 1, Product SKU: M-1038, Product Name: RJ45 8P8C Plug Flat Stranded 50pcs/Bag, Product Weight: 1, Product Variation Details: , Product Unit Price: 3.42, Product Total Price: 3.42|Product ID: 8940, Product Qty: 1, Product SKU: M-1385, Product Name: RJ11/12/45 Crimp Tool with Ratchet [HT-568R], Product Weight: 1, Product Variation Details: , Product Unit Price: 9.89, Product Total Price: 9.89

How can I add a <br> before every occurance of the term "Product" (without quotes).

That would make the output legible.

Should it be done client side, or server side.

I can use help for both.

Thanks in advance

[dagon]

inside the while() loop i assume you are using to write the output, showing us the code you are using would help

[jamesjohnson88]

$myString = output from above...

$newString = str_replace('Product', '</br>Product', $myString);

[dagon]

ouch, that does not look like data that should be in one table cell, normalisation would be the way to go.