I started using DataTables Table plug-in for jQuery and got some problems. I am using example code from here.
I have MySQL table witch looks like that:
id | name | father_id
father_id
is id
value in same table only in different row. So if I want to know father name i have to search in same table WHERE id = father_id
. But what DataTable does it just show the contents of MySQL table as it is.
In my DataTable i want to show data like that:
id | name | father_name | father_id
So when DataTable takes data from MySQL table, but before it creates table I want to change column value which at that time is value of father_id
in the same row in MySQL. I want too add father_name
by searching for it with particular father_id
.