Untitled

<html>
    <head>
        <title>Pilihan Berantai</title>
    </head>
    <body>
        <?php
//        koneksi ke database
        mysql_connect('localhost', 'username', 'password');
        mysql_select_db('namadatabase');
        ?>
        <form method="post">

            <!--provinsi-->
            <select id="provinsi" name="provinsi">
                <option value="">Please Select</option>
                <?php
                $query = mysql_query("SELECT * FROM provinsi ORDER BY nm_prov");
                while ($row = mysql_fetch_array($query)) {
                ?>
                    <option value="<?php echo $row['id_prov']; ?>">
                        <?php echo $row['nm_prov']; ?>
                    </option>
                <?php
                }
                ?>
            </select>

            <!--kota-->
            <select id="kota" name="kota">
                <option value="">Please Select</option>
                <?php
                $query = mysql_query("SELECT
                                    *
                                  FROM
                                    kota
                                    INNER JOIN provinsi ON kota.id_prov_fk = provinsi.id_prov ORDER BY nama_kota");
                while ($row = mysql_fetch_array($query)) {
                ?>
                    <option id="kota" class="<?php echo $row['id_prov']; ?>" value="<?php echo $row['id_kota']; ?>">
                        <?php echo $row['nama_kota']; ?>
                    </option>
                <?php
                }
                ?>
            </select>
        </form>

        <script src="jquery-1.10.2.min.js"></script>
        <script src="jquery.chained.min.js"></script>
        <script>
            $("#kota").chained("#provinsi");
        </script>

    </body>
</html>