게시판별 카테고리 만들기.

SQL 파일 첨부합니다.

[code]

<?php
include("conn.php");
#########input/edit example~~
echo "<form><div><select name=selects><option value=default selected disabled>선택</option>";
$board_sql="select * from `table`";
$board_result=mysqli_query($conn,$board_sql);
while($board=mysqli_fetch_assoc($board_result)) {
$tableidx=stripslashes($board['tableidx']);
$number=stripslashes($board['number']);
$title=stripslashes($board['title']);
$hit=stripslashes($board['hit']);
$title=stripslashes($board['title']);
$write=stripslashes($board['write']);
$day=stripslashes($board['day']);
$boardid=stripslashes($board['boardid']);
$tablecate_sql="select * from  `board-category` where `tableid` like '$boardid'";
$tablecate_result=mysqli_query($conn,$tablecate_sql);
$tablecate_total=mysqli_num_rows($tablecate_result);
//if(tablecate_total < 1 ) {}
//else {
while($cnscate=mysqli_fetch_assoc($tablecate_result)) {
$cateid=stripslashes($cnscate['cateid']);
$catename=stripslashes($cnscate['catename']);
echo "<option value=$cateid >$catename</option><input type=text name=test size=50 maxlength=50 value=abc><input type=submit value=posting></form></div>";}
}
?>

[/code]