답변 2개
답변에 대한 댓글 1개
댓글을 작성하려면 로그인이 필요합니다.
sql_query("insert into $makeTableName (`id`,`roomName`,`roomPrice`,`roomImage1`,`roomImage2`,`roomImage3`,`roomImage4`,`nobusyWeekPrice1`,`nobusyWeekPrice2`,`busyWeekPrice3`,`busyWeekPrice4`,`ableNum1`,`ableNum2`,`inner_struct`,`inner_product`,`etc`) values ('','으름방',20000,'','','','',10000,10000,10000,10000,7,7,NULL,NULL,'') "); } 마지막 라인이 으름방을 추가하는 쿼리인데 추가가 안되시나요.
쿼리문을 찍어보세여
위 라인을
$sql = "insert into $makeTableName (`id`,`roomName`,`roomPrice`,`roomImage1`,`roomImage2`,`roomImage3`,`roomImage4`,`nobusyWeekPrice1`,`nobusyWeekPrice2`,`busyWeekPrice3`,`busyWeekPrice4`,`ableNum1`,`ableNum2`,`inner_struct`,`inner_product`,`etc`) values ('','으름방',20000,'','','','',10000,10000,10000,10000,7,7,NULL,NULL,'') ");
echo $sql;
해서 쿼리 찍어보시고 직접 쿼리를 실행해보세여 무엇이 잘못되었는지 확인 될겁니다
댓글을 작성하려면 로그인이 필요합니다.
답변을 작성하려면 로그인이 필요합니다.
로그인
sql_query("insert into $makeTableName (`id`,`roomName`,`roomPrice`,`roomImage1`,`roomImage2`,`roomImage3`,`roomImage4`,`nobusyWeekPrice1`,`nobusyWeekPrice2`,`busyWeekPrice3`,`busyWeekPrice4`,`ableNum1`,`ableNum2`,`inner_struct`,`inner_product`,`etc`) values ('','포도방',10000,'','','','',10000,10000,10000,10000,7,7,NULL,NULL,'') ");
sql_query("insert into $makeTableName (`id`,`roomName`,`roomPrice`,`roomImage1`,`roomImage2`,`roomImage3`,`roomImage4`,`nobusyWeekPrice1`,`nobusyWeekPrice2`,`busyWeekPrice3`,`busyWeekPrice4`,`ableNum1`,`ableNum2`,`inner_struct`,`inner_product`,`etc`) values ('','머루방',10000,'','','','',10000,10000,10000,10000,7,7,NULL,NULL,'') ");
sql_query("insert into $makeTableName (`id`,`roomName`,`roomPrice`,`roomImage1`,`roomImage2`,`roomImage3`,`roomImage4`,`nobusyWeekPrice1`,`nobusyWeekPrice2`,`busyWeekPrice3`,`busyWeekPrice4`,`ableNum1`,`ableNum2`,`inner_struct`,`inner_product`,`etc`) values ('','달래방',10000,'','','','',10000,10000,10000,10000,7,7,NULL,NULL,'') ");
sql_query("insert into $makeTableName (`id`,`roomName`,`roomPrice`,`roomImage1`,`roomImage2`,`roomImage3`,`roomImage4`,`nobusyWeekPrice1`,`nobusyWeekPrice2`,`busyWeekPrice3`,`busyWeekPrice4`,`ableNum1`,`ableNum2`,`inner_struct`,`inner_product`,`etc`) values ('','다래방',10000,'','','','',10000,10000,10000,10000,7,7,NULL,NULL,'') ");
sql_query("insert into $makeTableName (`id`,`roomName`,`roomPrice`,`roomImage1`,`roomImage2`,`roomImage3`,`roomImage4`,`nobusyWeekPrice1`,`nobusyWeekPrice2`,`busyWeekPrice3`,`busyWeekPrice4`,`ableNum1`,`ableNum2`,`inner_struct`,`inner_product`,`etc`) values ('','두릅방',10000,'','','','',10000,10000,10000,10000,7,7,NULL,NULL,'') ");
sql_query("insert into $makeTableName (`id`,`roomName`,`roomPrice`,`roomImage1`,`roomImage2`,`roomImage3`,`roomImage4`,`nobusyWeekPrice1`,`nobusyWeekPrice2`,`busyWeekPrice3`,`busyWeekPrice4`,`ableNum1`,`ableNum2`,`inner_struct`,`inner_product`,`etc`) values ('','으름방',20000,'','','','',10000,10000,10000,10000,7,7,NULL,NULL,'') ");
}
소스는 이렇습니다. 마지막 으름방을 추가하려고 하는데 소스를 저렇게 쓰는게 아닌가요..?