Member Avatar for daneuchar


Hello,

i need to explode ( first img ) and put it in a table ( just like second output ) but i S*ck at exploding. kindly help me out in this

Thanks in advance

Regards
Daniel Euchar

Screenshot1.png 8.44 KB Screenshot2.png 7.64 KB
  • 2 Contributors
  • 1 Reply
  • 55 Views
  • 9 Hours Discussion Span
  • Latest Post Latest Post by diafol
Member Avatar for diafol

Is this php? Show us what you have so far.

Just a clue:

You need to explode twice. First case '/' or '#' on certain fields, although ',' for SCOPID.
The second explode is ',' on previously exploded fields (which will now be in the form of arrays).

This doesn't seem like the most efficient way of storing data, and as such, your output is more difficult than it needs to be. Programmatically adding data looks to be a nightmare - I assume that all this data has been entered manually?

I would suggest a number of linked tables for this. OK, so your SQL will be more complicated (using JOINS), but that's small potatoes.

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.