Menu

SELECT * FROM `tbl_apply` left join `tbl_activitie` on `tbl_apply`.`activitie_id` = `tbl_activitie`.`id` where `mid` = '98' AND `tbl_apply`.`id` = '642'

Array ( [0] => 1091 [id] => 1091 [1] => 98 [mid] => 98 [2] => 0 [cid] => 0 [3] => [type] => [4] => 2 [rank] => 2 [5] => 1 [status] => 1 [6] => [temp_post] => [7] => 計劃2019損益, 部署2020攻略 [name_hk] => 計劃2019損益, 部署2020攻略 [8] => 计劃2019损益, 部署2020攻略 [name_cn] => 计劃2019损益, 部署2020攻略 [9] => 計劃2019損益, 部署2020攻略 [name_en] => 計劃2019損益, 部署2020攻略 [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] => 2019-10-08 10:14:50 [date_crt] => 2019-10-08 10:14:50 [22] => 0 [date_crt_active] => 0 [23] => 2019-11-04 14:09:47 [date_mod] => 2019-11-04 14:09:47 [24] => 2019-10-31 00:00:00 [date_act] => 2019-10-31 00:00:00 [25] => 5 [create_by] => 5 [26] => 5 [mod_by] => 5 [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] => t2c [wordc_en] => t2c [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,6,7 [membership_id] => all,login,1,2,4,5,3,6,7 [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 )