1개의 form 에서 넘어오는 값을 2개의 table 에 저장 시키고 시퍼요 ~ 채택완료
하내따남
10년 전
조회 1,912
</p><p><span class="Apple-tab-span" style="white-space:pre"> </span>$sql4 = "insert into {$g5['g5_pg_table']}</p><p> set $sql_common2";</p><p><span class="Apple-tab-span" style="white-space:pre"> </span>sql_query($sql4);</p><p><span class="Apple-tab-span" style="white-space:pre"> </span></p><p><span class="Apple-tab-span" style="white-space:pre"> </span></p><p> </p><p> $sql = "insert into {$g5['g5_product_table']}</p><p> set $sql_common";</p><p> sql_query($sql);</p><p>
위와 같은 방법으로 쿼리를 날리고 있습니다.
문제점은 1개의 쿼리만 날릴때에는 정상적으로 값이 들어가고 있습니다.
그런데 지금 하고 있는 부분이 1개의 form 에서 넘어오는 값을 가지고
2개의 table 에 저장 하고자 하는데 저렇게 날리니 1개의 form 그것도 아래쪽에 위치한
쿼리만 먹히고 위쪽에 있는 쿼리는 작동을 하지 않습니다.
혹시 몰라서 $sql_common 들에 담겨있는 것도 올립니다.
</p><p> </p><p>$sql_common = " </p><p><span class="Apple-tab-span" style="white-space:pre"> </span>product_nm<span class="Apple-tab-span" style="white-space:pre"> </span> = '$product_nm',</p><p><span class="Apple-tab-span" style="white-space:pre"> </span>frame<span class="Apple-tab-span" style="white-space:pre"> </span> = '$frame',</p><p><span class="Apple-tab-span" style="white-space:pre"> </span>p_price<span class="Apple-tab-span" style="white-space:pre"> </span> = '$p_price',</p><p><span class="Apple-tab-span" style="white-space:pre"> </span>sort_no<span class="Apple-tab-span" style="white-space:pre"> </span> = '$sort_no',</p><p><span class="Apple-tab-span" style="white-space:pre"> </span>p_text<span class="Apple-tab-span" style="white-space:pre"> </span> = '$p_text',</p><p><span class="Apple-tab-span" style="white-space:pre"> </span>dual_win<span class="Apple-tab-span" style="white-space:pre"> </span> = '$dual_win',</p><p><span class="Apple-tab-span" style="white-space:pre"> </span>display_p<span class="Apple-tab-span" style="white-space:pre"> </span> = '$display_p',</p><p><span class="Apple-tab-span" style="white-space:pre"> </span>p_id<span class="Apple-tab-span" style="white-space:pre"> </span> = '$p_id',</p><p><span class="Apple-tab-span" style="white-space:pre"> </span>p_img1<span class="Apple-tab-span" style="white-space:pre"> </span> = '$p_img1',</p><p><span class="Apple-tab-span" style="white-space:pre"> </span>p_img2<span class="Apple-tab-span" style="white-space:pre"> </span> = '$p_img2',</p><p><span class="Apple-tab-span" style="white-space:pre"> </span>p_img3<span class="Apple-tab-span" style="white-space:pre"> </span> = '$p_img3',</p><p><span class="Apple-tab-span" style="white-space:pre"> </span>p_img4<span class="Apple-tab-span" style="white-space:pre"> </span> = '$p_img4',</p><p><span class="Apple-tab-span" style="white-space:pre"> </span>p_img5<span class="Apple-tab-span" style="white-space:pre"> </span> = '$p_img5',</p><p><span class="Apple-tab-span" style="white-space:pre"> </span>p_img6<span class="Apple-tab-span" style="white-space:pre"> </span> = '$p_img6',</p><p><span class="Apple-tab-span" style="white-space:pre"> </span>p_img7<span class="Apple-tab-span" style="white-space:pre"> </span> = '$p_img7',</p><p><span class="Apple-tab-span" style="white-space:pre"> </span>p_img8<span class="Apple-tab-span" style="white-space:pre"> </span> = '$p_img8',</p><p><span class="Apple-tab-span" style="white-space:pre"> </span>p_img9<span class="Apple-tab-span" style="white-space:pre"> </span> = '$p_img9',</p><p><span class="Apple-tab-span" style="white-space:pre"> </span>p_img10<span class="Apple-tab-span" style="white-space:pre"> </span> = '$p_img10'</p><p> ";</p><p> </p><p>$sql_common2 = "</p><p><span class="Apple-tab-span" style="white-space:pre"> </span>pg_index<span class="Apple-tab-span" style="white-space:pre"> </span> = '0',</p><p><span class="Apple-tab-span" style="white-space:pre"> </span>p_idx<span class="Apple-tab-span" style="white-space:pre"> </span> = '$p_id',</p><p><span class="Apple-tab-span" style="white-space:pre"> </span>g_idx<span class="Apple-tab-span" style="white-space:pre"> </span> = '$select_g',</p><p><span class="Apple-tab-span" style="white-space:pre"> </span></p><p><span class="Apple-tab-span" style="white-space:pre"> </span>";</p><p>
뭐가 문제인지 봐주세요
댓글을 작성하려면 로그인이 필요합니다.
답변 2개
채택된 답변
+20 포인트
10년 전
$sql_common2
제일 아래에
<code class="plain" style="font-size: 14.004px; line-height: 25.2072px; letter-spacing: -0.01px; font-family: Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace !important; margin: 0px !important; padding: 0px !important; border: 0px !important; outline: 0px !important; float: none !important; vertical-align: baseline !important; position: static !important; left: auto !important; top: auto !important; right: auto !important; bottom: auto !important; height: auto !important; width: auto !important; background-image: none !important; background-attachment: initial !important; background-color: rgb(248, 248, 248); background-size: initial !important; background-origin: initial !important; background-clip: initial !important; background-position: initial !important; background-repeat: initial !important;">g_idx = </code><code class="string" style="font-size: 14.004px; line-height: 25.2072px; letter-spacing: -0.01px; font-family: Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace !important; margin: 0px !important; padding: 0px !important; border: 0px !important; outline: 0px !important; float: none !important; vertical-align: baseline !important; position: static !important; left: auto !important; top: auto !important; right: auto !important; bottom: auto !important; height: auto !important; width: auto !important; color: blue !important; background-image: none !important; background-attachment: initial !important; background-color: rgb(248, 248, 248); background-size: initial !important; background-origin: initial !important; background-clip: initial !important; background-position: initial !important; background-repeat: initial !important;">'$select_g'</code><code class="plain" style="font-size: 14.004px; line-height: 25.2072px; letter-spacing: -0.01px; font-family: Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace !important; margin: 0px !important; padding: 0px !important; border: 0px !important; outline: 0px !important; float: none !important; vertical-align: baseline !important; position: static !important; left: auto !important; top: auto !important; right: auto !important; bottom: auto !important; height: auto !important; width: auto !important; background-image: none !important; background-attachment: initial !important; background-color: rgb(248, 248, 248); background-size: initial !important; background-origin: initial !important; background-clip: initial !important; background-position: initial !important; background-repeat: initial !important;">,여기에서 ,(콤마)를 빼 보세요.
로그인 후 평가할 수 있습니다
답변에 대한 댓글 1개
�
하내따남
10년 전
댓글을 작성하려면 로그인이 필요합니다.
답변을 작성하려면 로그인이 필요합니다.
로그인
아흑 ㅠㅠ