SELECT * FROM `tbl_apply` left join `tbl_activitie` on `tbl_apply`.`activitie_id` = `tbl_activitie`.`id` where `mid` = '98' AND `tbl_apply`.`id` = ''
Array ( [0] => 112 [id] => 112 [1] => 98 [mid] => 98 [2] => 0 [cid] => 0 [3] => [type] => [4] => 21 [rank] => 21 [5] => 1 [status] => 1 [6] => [temp_post] => [7] => 什麽是整形外科? [name_hk] => 什麽是整形外科? [8] => 什麽是整形外科? [name_cn] => 什麽是整形外科? [9] => What is Plastic Surgery? [name_en] => What is Plastic Surgery? [10] => [go_url_hk] => [11] => [go_url_cn] => [12] => [go_url_en] => [13] => [url_input_hk] => [14] => [url_input_cn] => [15] => [url_input_en] => [16] => [content_hk] => [17] => [content_cn] => [18] => [content_en] => [19] => 0 [pub_fm] => 0 [20] => 0 [pub_to] => 0 [21] => 2015-12-10 10:45:20 [date_crt] => 2015-12-10 10:45:20 [22] => 0 [date_crt_active] => 0 [23] => 2017-11-21 10:25:50 [date_mod] => 2017-11-21 10:25:50 [24] => 2015-03-26 00:00:00 [date_act] => 2015-03-26 00:00:00 [25] => 1 [create_by] => 1 [26] => 1 [mod_by] => 1 [27] => 0 [mod_version] => 0 [28] => 0 [mod_lock] => 0 [29] => 0 [mod_lock_exp] => 0 [30] => 0 [access] => 0 [31] => no [share] => no [32] => 0 [hits] => 0 [33] => t2c [wordc_hk] => t2c [34] => t2c [wordc_cn] => t2c [35] => [wordc_en] => [36] => [url_hk] => [37] => [url_cn] => [38] => [url_en] => [39] => 0 [url_pop] => 0 [40] => [thumb_hk] => [41] => [thumb_cn] => [42] => [thumb_en] => [43] => 0 [sphoto] => 0 [44] => 0 [sattach] => 0 [45] => all,login,1,2,4,5,3 [membership_id] => all,login,1,2,4,5,3 [46] => [time] => [47] => 0 [fee] => 0 [48] => 0 [places] => 0 [49] => [address_hk] => [50] => [address_cn] => [51] => [address_en] => [52] => 1 [sns_share] => 1 [53] => 0 [youth_share] => 0 [54] => 0 [look] => 0 [55] => 0 [file_id] => 0 [56] => [repeat_date] => [57] => 1 [banner_display_nr] => 1 )