I will explain with the help of an example. Suppose its a library system whereby the user enters the ISBN number. The database must be queried and display the availabity of the book. If the book is available, the user can then borrow the book online and then automatically the number of books with the same ISBN number should be reduced by one.
Table structure for the mysql table for book availability.
ISBN number, Title, Author, Publisher, AvailableY/N
I wanted to know if there is any plugin that I can activate to make thinks easier.