connect_db($hostname,$user,$passwd);
$db=mysql_select_db($dbname);
$sql="insert into book (Book_name,Book_detail,Book_price,Book_stro,BT_id,Sup_id,Book_cost) values ('$Book_name','$Book_detail','$Book_price','$Book_stro','$BT_id','$Sup_id','$Book_cost')";
$result=mysql_query($sql);
$lastid=mysql_insert_id();
$path="Book_pic";
if(!empty($Book_pic))
{
copy($Book_pic,"$path/$lastid$PhotoType");
$Book_pic=$lastid.$PhotoType;
$sqlpic="Update book set Book_pic ='$Book_pic' where Book_id='$lastid'";
$resultpic=mysql_query($sqlpic);
}else{
$sqlpic="Update book set Book_pic ='nopic.gif' where Book_id='$lastid'";
$resultpic=mysql_query($sqlpic);
}