DB array

[dannybrazil]

Hello

 

I have a DB table which contains a col with information [code_of_product - quantity]:

 

Example:

12345 - 12 , 6789 - 8 , 54321 - 3.

 

Now as they are all in ONE CELL I wanted to know if there is a way to SEPARATE them according to the "," and "-"

 

Like this:

 

Product 12345 - Quantity 12

(<br>)

Product 6789 - Quantity 8

.

.

.

etc

 

any help?

[Jessica]

Google "data normalization". You need to store your data differently, as you've discovered the way you're doing it causes problems as soon as you want to actually use the data.

[Barand]

I totally agree with Jessica about the normalisation. This is not the way you should be storing your data.

 

But you will need to know how to extract the data in order to create a properly normalised table, so

 

$col_data = "12345 - 12 , 6789 - 8 , 54321 - 3";

$items = explode(' , ', $col_data);

foreach ($items as $item) {
   list($product, $qty) = explode(' - ', $item);
   echo "Product $product - Quantity $qty<br>";
}