<table border="1">
   <tr><td><input type="text" name="Acc1" /> - <input type="text" name="Acc2" /> </td></tr>
</table>

<?php
   $Acc1 = $_POST['Acc1'];
   $Acc2 = $_POST['Acc2'];

   if(isset($_POST['save'])){

      do{
          $Save = mysql_query("SELECT * FROM BOOK WHERE Accession_No = '".$Acc1++."'");
          $Save_Query = mysql_num_rows($Save);

      }while($Acc1 <= $Acc2);
   }

   if($Save_Query > 0 ){
      echo "<script language=javascript>
      alert('Accession Number is already taken.');
      </script>";
   }

   do{
     mysql_query("INSERT INTO BOOK('Accession')VALUES('".$Acc1."')");

   }while($Acc1 <= $Acc2);

      echo "<script language=javascript>
      alert('Successfully Saved.');
      location.href = 'Home.php';
      </script>";

?>