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.

Click Here

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.

Be a part of the DaniWeb community

We're a friendly, industry-focused community of 1.18 million developers, IT pros, digital marketers, and technology enthusiasts learning and sharing knowledge.