This question already has an answer here:
i'am using datatable server side processing. i wanna modify my script to use CURDATE to show age in my table.
$columns = array(
array( 'db' => 'nkk', 'dt' => 0 ),
array( 'db' => 'nik', 'dt' => 1 ),
array( 'db' => 'kecamatan', 'dt' => 2 ),
array( 'db' => 'kelurahan', 'dt' => 3 ),
array( 'db' => 'nama', 'dt' => 4 ),
array( 'db' => 'tempat_lahir', 'dt' => 5 ),
array( 'db' => 'tanggal_lahir', 'dt' => 6 ),
array( 'db' => 'status_perkawinan', 'dt' => 7 ),
array( 'db' => 'jenis_kelamin', 'dt' => 8 ),
array( 'db' => 'alamat', 'dt' => 9 ),
array( 'db' => '(SELECT 'tb_dpt_biringkanaya'.'tanggal_lahir',YEAR(CURDATE())-YEAR('tb_dpt_biringkanaya'.'tanggal_lahir') AS 'usia' FROM 'tb_dpt_biringkanaya')", 'dt' => 10 ),
array( 'db' => 'tps', 'dt' => 11),
array( 'db' => 'agama', 'dt' => 12 ),
array( 'db' => 'group_jemaat', 'dt' => 13 ),
array( 'db' => 'status', 'dt' => 14 ),
but error like this. Parse error: syntax error, unexpected 'tb_dpt_biringkanaya' (T_STRING), expecting ')' in C:\xampp\htdocs\mariodavdpt\data\load_data_biringkanaya.php on line 50.
please help to solved my problem, thanks.
</div>