Server-side processing combine multiple DB columns for single DT column with delimiters

theshadow124

Hey all, I'm new to this forum but not new to data tables and am having a issue with setting up server-side processing using the default sip.class.php

If you want to see my first question on this topic over on stack overflow: http://stackoverflow.com/questions/33860060/datatables-format-column-from-multiple-sourcesserver-side-processing

I have a SQL database:

id: key, integer, unique
name: string
street: string
city: string
postal: string
country: string

I want to display:

+==+=====+=======================================+

| id | Name | Address |

+==+=====+=======================================+

| 1 | test | $street . " " . "$city . "<br>" . $postal . " " . $country |

+==+=====+=======================================+

| .... | ......... | ........ |

+==+=====+=======================================+

^^ formatting gets screwed up in previewer I hope this makes sense.

The only thing I could find online about this was this post: http://stackoverflow.com/questions/29147633/datatables-server-side-processing-db-column-merging

But this doesn't work(please see my stack overflow post above)

Please tell me this is possible, the current website is running based on keeping specific fields separate in the database for other functions.

theshadow124

if anyone else is having the same issue refer to the stack overflow post