ใช้การตัดคำ แล้วให้ข้อมูลวิ่งไปในฐานข้อมูล แต่ข้อมูลเข้าได้ข้อมูลเดียว

<?
@mysql_connect("localhost","root","1234") ;
@mysql_select_db("book1") ;
mysql_query("SET NAMES TIS620");
$result=mysql_query("SELECT * FROM `book1`");
$array=array("A","B","C","D","E","F","G","H","J","K","L","M","N","P","Q","R","S","T","U","V","Z");
while($a=mysql_fetch_array($result)){
$biblio=$a['BIBLIO'];
$firsttext=substr($biblio,0,1);
$$firsttext++;
}
foreach($array as $b){
print "Group $b = ".$$b."<br>";
$insert=mysql_query("insert into `book_type3` (code,quantity) values ('$b','".$$b."')");
}
$num=mysql_num_rows($result);
print "Total is $num";
?>