= 3){
echo "";
}elseif ($count_array['book_id'] == $book_id){
echo "";
}else{
$update_copies = mysql_query ("SELECT * from book where book_id = '$book_id' ") or die (mysql_error());
$copies_row= mysql_fetch_assoc($update_copies);
$book_copies = $copies_row['book_copies'];
$new_book_copies = $book_copies - 1;
if ($new_book_copies == 4){
echo "";
}else{
mysql_query("UPDATE book SET book_copies = '$new_book_copies' where book_id = '$book_id' ") or die (mysql_error());
mysql_query("INSERT INTO borrow_book(user_id,book_id,date_borrowed,due_date,borrowed_status)
VALUES('$user_id','$book_id','$date_borrowed','$due_date','borrowed')") or die (mysql_error());
}
}
?>