<?php
include('config.php');// connection to database
?>

<form name="" action="" method="POST">
<select class="btn dropdown-toggle clearfix btn-hg btn-primary" name="school_ebook" data-toggle="dropdown" style="width: 200px;">
                    <?php
                        $result1=mysql_query("SELECT * FROM school GROUP BY SCHOOL_NAME");

                        while($row1=mysql_fetch_array($result1))
                        {
                    ?>
                        <option><?php echo $row1['SCHOOL_NAME'];?></option>
                    <?php
                        }
                    ?>
                    </select>

<table class="table table-striped table-hover table-bordered datatable">
                    <thead style="background: #a83535; color: black;">
                        <tr>
                            <th style="width: 50px;"></th>
                            <th style="color: #3b3b3b;">Ebook Title</th>
                            <th style="color: #3b3b3b;">Category</th>
                            <th style="color: #3b3b3b;">File Name</th>
                        </tr>
                    </thead>
                    <tbody>
                    <?php
                            $result=mysql_query("SELECT * from ebooks ORDER BY EBOOK_TITLE");
                            $count=mysql_num_rows($result);
                            while($row=mysql_fetch_array($result))
                            {
                    ?>
                        <tr>
                            <td>
                                <center><input type="checkbox" name="check[]" ></center>
                            </td>
                            <td><input type="" name="ebookname[]" value="<?php echo $row['EBOOK_TITLE'];?>"></label></td>
                            <td><input type="" name="ebookcategory[]" value="<?php echo $row['EBOOK_CATEGORY'];?>"></label></td>
                            <td><input type="label" name="ebookfilename[]" value="<?php echo $row['EBOOK_FILENAME'];?>"></label></td>
                        </tr>
                    <?php
                        }//end of while loop
                    ?>
                    </tbody>
                </table>

<button type="submit" class="btn btn-hg btn-primary" name="AddEbooks">
                Submit
            </button>