¾Æ·¡¿Í °°Àº Å×À̺íÀÌ µÎ°³°¡ ÀÖ½À´Ï´Ù. uid = board_id À̱¸¿ä.
µÎ°³ÀÇ Å×À̺íÀ» ÂüÁ¶ÇÏ°í Á¶°Ç ¹®Àº b.official_notice_type ÀÔ´Ï´Ù.
select uid, board_name from wp_kboard_board_setting;
+-----+------------+
| uid | board_name |
+-----+------------+
| 1 | test-1 |
| 2 | test-2 |
+-----+------------+
select board_id, `key`, value from wp_kboard_board_meta;
+----------+----------------------+--------------------------+
| board_id | key | value |
+----------+----------------------+--------------------------+
| 1 | auto_page | 2 |
| 1 | official_notice_type | °úÇй®ÈÈ®»ê»ç¾÷ |
| 1 | open_cycle | ºÐ±â |
| 1 | open_time | ºÐ±â ÃÊ |
| 1 | open_type | ȨÆäÀÌÁö |
| 2 | official_notice_type | ±âŸ |
| 2 | auto_page | 42 |
| 2 | open_cycle | 4°³¿ù |
| 2 | open_time | ÇϹݱâ |
| 2 | open_type | ȨÆäÀÌÁö |
+----------+----------------------+--------------------------+
Á¦°¡ ¿øÇÏ´Â °á°ú´Â ÀÌ·±±¸Á¶ ÀÔ´Ï´Ù.
+-----+------------+--------------------------+-----------+------------+------------+--------------+
| uid | board_name | official_notice_type | auto_page | open_cycle | open_time | open_type |
+-----+------------+--------------------------+-----------+------------+------------+--------------+
| 1 | test-1 | °úÇй®ÈÈ®»ê»ç¾÷ | 2 | ºÐ±â | ºÐ±â ÃÊ | ȨÆäÀÌÁö |
+-----+------------+--------------------------+-----------+------------+------------+--------------+
¿öµåÇÁ·¹½º ±Û·Î¹ú °´Ã¼ÀÎ $wpdb->get_results($query) ·Î ±¸Çö ÇØ¾ß Çϴµ¥¿ä
Äֻܼ󿡼 mysql¿¡ Á÷Á¢ Äõ¸®¸¦ ³¯¸®¸é Àú ÇüÅÂÀÇ °á°ú´Â ³ª¿É´Ï´Ù.
±×·±µ¥ $wpdb->get_results ¸¦ »ç¿ëÇÏ¸é ¼ºê Äõ¸®¸¦ ³Ê¹« ½á¼ ±×·±Áö, Á¦¾à¿¡ °É¸®´ÂÁö.. null °ªÀÌ ¸®Åϵdz׿ä
¾Æ·¡ Äõ¸®Á» ´Ùµë¾î Áֽðųª ¿øÇÏ´Â ÇüÅ·Π³ª¿À°Ô µµ¿ÍÁÖ¼¼¿ä ¤Ð¤Ð¤Ð
ps. ¶Ë Äõ¸® Åõô!!
select * from (select uid, board_name, (select value from wp_kboard_board_meta where board_id = uid and `key` = 'official_notice_type') as official_notice_type, (select value from wp_kboard_board_meta where board_id = uid and `key` = 'auto_page') as auto_page, (select value from wp_kboard_board_meta where board_id = uid and `key` = 'open_cycle') as open_cycle, (select value from wp_kboard_board_meta where board_id = uid and `key` = 'open_time') as open_time, (select value from wp_kboard_board_meta where board_id = uid and `key` = 'open_type') as open_type from wp_kboard_board_setting) a where a.official_notice_type = '°úÇй®ÈÈ®»ê»ç¾÷';
Àâ´ã | 2066¸íÀÌ Àоú¾î¿ä. 18.116.21.229