ȨÀ¸·Î | ¹«·áȸ¿ø°¡ÀÔ | ¾ÆÀ̵ð/ºñ¹øÃ£±â
ÃßõÀ½¾Ç¹æ¼Û
5¹øÀÇ SQLÀ» ¾èº¸Áö ¸¶¶ó
11³â Àü
OOO ùȭ¸éÀÇ ÅÇ Ãֽűۿ¡´Â ÅÇ¿¡ »ç¿ëµÇ´Â 5°³ÀÇ °Ô½ÃÆÇ À̸§À» ¾ò±â À§Çؼ­

5¹øÀÇ SQLÀ» ¼öÇà ÇÏ°Ô µÇ¾î ÀÖ½À´Ï´Ù. ÀÌ·± ÅÇÀÌ 3°³ »ç¿ëµÇ¾úÀ¸´Ï, ±âº»À¸·Î

1ÆäÀÌÁö¿¡ 15°³ÀÇ SQLÀÌ »ç¿ëµÈ °ÍÀÌÁÒ. À̰ÍÀ» 3¹ø¸¸ Çϸé È¿°ú°¡ ¾î´ÀÁ¤µµ Àϱî¿ä?



ÇØº¸´Ï±î ¿µÇâÀÌ ¾ÆÁÖ ¾ÆÁÖ ¸¹ÀÌ Å®´Ï´Ù. ¤¾¤¾


12°³ÀÇ SQLÀº Á¢¼Ó·®ÀÌ ¸¹Àº »çÀÌÆ®¿¡¼­´Â ¼ø°£ÀûÀÎ ÆøÅºÀÌ µÉ ¼ö ÀÖ½À´Ï´Ù.


(¿øº»)

// ¾Æ·¡ ºÎºÐ Å×À̺í¸í
$my_table1 = 'myinfo';
$my_table2 = 'btr';
$my_table3 = 'bed';
$my_table4 = 'bed_gh';
$my_table5 = 'eat';



$sql1 = "select bo_subject from $g4[board_table] where bo_table='$my_table1'";
$sql2 = "select bo_subject from $g4[board_table] where bo_table='$my_table2'";
$sql3 = "select bo_subject from $g4[board_table] where bo_table='$my_table3'";
$sql4 = "select bo_subject from $g4[board_table] where bo_table='$my_table4'";
$sql5 = "select bo_subject from $g4[board_table] where bo_table='$my_table5'";
$bo_name_sql1 = sql_query($sql1);
$bo_name1 = sql_fetch_array($bo_name_sql1);
$bo_name_sql2 = sql_query($sql2);
$bo_name2 = sql_fetch_array($bo_name_sql2);
$bo_name_sql3 = sql_query($sql3);
$bo_name3 = sql_fetch_array($bo_name_sql3);
$bo_name_sql4 = sql_query($sql4);
$bo_name4 = sql_fetch_array($bo_name_sql4);
$bo_name_sql5 = sql_query($sql5);
$bo_name5 = sql_fetch_array($bo_name_sql5);




(¼öÁ¤)



$sql = " select bo_table, bo_subject from $g4[board_table] where bo_table in('$my_table1','$my_table2','$my_table3','$my_table4','$my_table5') ";
$result = sql_query($sql);
$arr = array();
while ($row = sql_fetch_array($result))
{
    $bo_table = $row[bo_table];
    $arr[$bo_table] = $row[bo_subject];
};

$bo_name1[bo_subject] = $arr[$my_table1];

$bo_name2[bo_subject] = $arr[$my_table2];
$bo_name3[bo_subject] = $arr[$my_table3];
$bo_name4[bo_subject] = $arr[$my_table4];
$bo_name5[bo_subject] = $arr[$my_table5];
ÃßõÃßõ : 215 Ãßõ ¸ñ·Ï
¹øÈ£ Á¦¸ñ
3,030
 Á¦ÀÌÄõ¸® ±âº» ¸í·É¾î
3,029
 À¥ÆäÀÌÁö °¡·Î ¸ðµå¼¼·Î ¸ðµå ÀνÄÇϱâ
3,028
 ¸ð¹ÙÀÏ À¥ È­¸é °­Á¦ ȸÀü(°¡·Î¸ðµå °íÁ¤)
3,027
 [HTML5]¿¡¼­ frameset ´ëü ¹æ¹ý°ú iframe ¼Ó¼º
3,026
 HTML <Audio> »ç¿ë¹ý
3,025
 À©µµ¿ì10 ½Ã½ºÅÛÆÄÀÏ ¼Õ»ó (Ãʰ£´Ü ¿À·ù º¹±¸¹æ¹ý!!)
3,024
 PHP ÆÄÀÏ Á¸Àç ¿©ºÎ ÆÄ¾ÇÇϱâ(·ÎÄà ÆÄÀÏ Á¸Àç ¹× ¿ø°ÝÁö ÆÄÀÏ Á¸Àç)
3,023
 [CSS] ¹Ú½º ¼¼·Î °¡¿îµ¥ Áß¾Ó Á¤·Ä 6°¡Áö
3,022
 CSS Layout ¼öÆò & ¼öÁ÷ Á¤·Ä
3,021
 ¿©·¯ µµ¸ÞÀÎµé °£ ÄíŰ °øÀ¯Çϱâ
3,020
 ÅÂ±× »çÀÌ¿¡ ÀÖ´Â ÅØ½ºÆ®¸¦ ÃßÃâ
3,019
 [JQuery] textbox focus on offÀ϶§ ¼ýÀÚ ÄÞ¸¶ º¸¿©ÁÖ±â
3,018
 ÄíŰ »ý¼º,°¡Á®¿À±â,»èÁ¦
3,017
 »ç¿ëÀÚ ÇÔ¼ö ¸ðÀ½
3,016
 ¸¶¿ì½º,Űº¸µå Á¦ÇÑ ( ¿À¸¥ÂÊŬ¸¯,µå·¡±×,¿µ¿ª¼±Åõî..)
3,015
 [HTML5] <video> - DOMÀ¸·Î Á¦¾îÇϱâ
3,014
 HTML5 video ű׿¡¼­ ¿µ»ó Á¿ì¹ÝÀü
3,013
 PHP - ƯÁ¤ ÅÂ±× ¹× ¹®ÀÚ¿­ ÃßÃâ, Á¦°Å
3,012
 [PHP] define°ú definedÀÇ Â÷ÀÌ
3,011
 ¿ìŬ¸¯ ¿Ïº®Â÷´Ü ½ºÅ©¸³Æ®
3,010
 iframe ³ôÀÌ 100% ¸ÂÃß±â
3,009
 curl ÇÔ¼ö¸¦ ÀÌ¿ëÇÑ HTTP REFERER º¯°æ
3,008
 À©µµ¿ì10 ½Ã½ºÅÛ ÆÄÀÏ ¹× Dism °Ë»ç
3,007
 ÅؽºÆ® ÁٹٲÞ, ±ÛÀÚÀÚ¸£±â CSS
3,006
 jQuery Mobile¿¡¼­ À¯¿ëÇÑ ÄÚµå 10°¡Áö.
¸ñ·Ï
¹ÂÁ÷Æ®·ÎÆ® ºÎ»ê±¤¿ª½Ã ºÎ»êÁø±¸ °¡¾ßµ¿ ¤Ó °³ÀÎÁ¤º¸Ãë±Þ¹æÄ§
Copyright (C) musictrot All rights reserved.