MySQL Forums
Forum List  »  MySQL Query Browser

Complex MySQL Query
Posted by: wryfhk22 jiji
Date: March 29, 2011 09:36PM

Hi friends,

My brother has a table that contains book purchase information for an online book shop.
The database structure can be found below:

* Purchase_ID:
Used as a unique identifier for the purchase

* Book_ID:
Used to store the book that was purchased

* Customer_ID:
Used to store the book purchaser

* Purchase_Date:
Used to store the purchase date.

* Book_Selected:
Define whether or not book is entered into competition.


Upon clicking a link containing a particular "Purchase ID", how does he change the value of the "Book_Selected" field to "1", whilst changing the "Book_Selected" field values to "2" for any other Purchase ID's that have the same "Book ID".

Thanks in advance

Options: ReplyQuote


Subject
Written By
Posted
Complex MySQL Query
March 29, 2011 09:36PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.