can you help me in 1 cell in a row can handle many data ?
for example in the picture
for costumer 1, he order a
banana, it cost 50
apple, it cost 60
orange, it cost 70
and my program will retrieve the datas and
it will get the fruit name and it cost.
It would be much simpler if you use an additional table, instead of this, so you can have one row for each item.
Yes having it designed in that way takes away the advantage of using any mysql functions like sort by or order by.
You add an additional cost in that you need to parse out the data using a server side language such as php.
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.