![1443812343_1.PNG](//cdn2.ppomppu.co.kr/zboard/data3/2015/1003/1443812343_1.PNG)
![1443812350_2.PNG](//cdn2.ppomppu.co.kr/zboard/data3/2015/1003/1443812350_2.PNG)
À§ »çÁøÀ» º¸½Ã¸é¾Ë°ÚÁö¸¸ ÀÌ·¸°Ô µ¥ÀÌÅÍ º£À̽º¿¡ µ¥ÀÌÅ͵éÀÌ µé¾î°¡ÀÖ±¸¿ä
![1443813302_qry.PNG](//cdn2.ppomppu.co.kr/zboard/data3/2015/1003/1443813302_qry.PNG)
ÀÌ·¸°Ô query¹®À» ³¯·Áº¸´Ï °á°ú °ªÀÌ ³ª¿Ô½À´Ï´Ù.
±×·±µ¥ php¿¡¼
$qry = "SELECT A.userid userid, A.nickname nickname, A.name name, A.type type, A.country country, A.timer timer, B.filename filename, B.filepath filepath FROM itu_recipe A inner join itu_recipe_imgfile B WHERE A.name = B.name AND B.name='±èÄ¡ººÀ½¹ä'";
ÀÌ·¸°Ô ¶È°°ÀÌ Äõ¸®¹®À» ³¯·ÁºÃ´Âµ¥
¹«½¼ ¿µ¹®ÀÎÁö....;;
°á°ú °ªÀÌ ¾È³ª¿À³×¿ä....
$qry = "SELECT A.userid userid, A.nickname nickname, A.name name, A.type type, A.country country, A.timer timer, B.filename filename, B.filepath filepath FROM itu_recipe A inner join itu_recipe_imgfile B WHERE A.name = B.name AND A.name='±èÄ¡ººÀ½¹ä'";
ÀÌ·¸°Ô Çصµ ¾È³ª¿À±¸¿ä
±×·±µ¥
$qry = "SELECT A.userid userid, A.nickname nickname, A.name name, A.type type, A.country country, A.timer timer, B.filename filename, B.filepath filepath FROM itu_recipe A inner join itu_recipe_imgfile B WHERE A.name = B.name";
ÀÌ·¸°Ô Çؼ
while($row = mysql_fetch_array($result)){
echo $row[userid];
echo $row[nickname];
echo $row[name];
echo $row[type];
echo $row[country];
echo $row[timer];
echo $row[filename];
echo $row[filepath];
}
ÀÌ·±½ÄÀ¸·Î Ãâ·ÂÇϸé
¶Ç µ¥ÀÌÅÍ°¡ µÈÀåÂî°³ , ±èÄ¡ººÀ½¹äÀÇ µ¥ÀÌÅÍ°¡ 2°³°¡ Ãâ·ÂÀÌ µÇ¿ä;;;
¿ø·¡´Â 3°³°¡ ³ª¿Í¾ß ÇÏÁö¸¸.... 2°³¶óµµ ÀÏ´Ü Ãâ·ÂÀº µÇ´Âµ¥...
¹«½¼ ÀÌÀ¯ Àϱî¿ä ¤Ì¤Ì? | |
|
ÀÌ°É ÇÏ¸é °á°ú°ªÀº 2°³°¡ ³ª¿À´Â°Ç ¹½¶§¹®ÀÌÁÒ ¤Ì¤Ì?
myAdmin ¿¡¼ °Ë»öÇÏ´Â°Ç 3°³ÀÇ °á°ú°¡ ³ª¿À´Âµ¥...