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

Recommended Answers

All 2 Replies

It would be much simpler if you use an additional table, instead of this, so you can have one row for each item.

Member Avatar for iamthwee

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 developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.