Member Avatar for sibymary

how to update single row from table by using a single sql query.
here im using library system.when a book is issued to the user,it should be updated to database, only which book is issued

Edited by sibymary because: n/a
  • 2 Contributors
  • 1 Reply
  • 108 Views
  • 6 Hours Discussion Span
  • Latest Post Latest Post by pritaeas
Member Avatar for pritaeas

You can use something like

UPDATE `books` SET available = available - 1 WHERE book_id = <book id here>
Edited by pritaeas because: n/a
Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.