Member Avatar for LRNPHP

Hi There,

I would like to know if it's possible to use or what I could use to get the required results.

The values

+2711
 081
 076
 086
 080
 9011
 6547082
 9013
 9039
 9086
 9041
 +27084
substring(table,length(tbl_code),length(tbl_code))=trim(tbl_code)

I have different values lengths in my MySQL table that's not showing all my values correctly.

substring(table,1,length(tbl_code))=trim(tbl_code)

Kind Regards

  • 2 Contributors
  • 1 Reply
  • 119 Views
  • 2 Days Discussion Span
  • Latest Post Latest Post by twiss
Member Avatar for twiss

It might be just me, but I've got no clue what you want to do whatsoever. What are those values, where do they come from, what has to be done with them, what doesn't show correctly, etc.

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.