I am working in an online website for selling books.
There is a table where the sold books are stored, like this:
id | int - autoincrement
CustomerID (foreing key to table Customers)
BookID (foreign key to table Books)
How can I calculate the total quantity of sold books of each one?
For instance, having 'n' books, how many BookID = 1 to n have been sold (how many of each one)?
Thanks a lot!!!
, COUNT(*) AS Total
GROUP BY BookID
One last question please. Where are the result stored and how can I read them?
I understand I have to run this query and assign a variable to the result.
Is this result an array, having the totals of each BookID per rows?
Thanks a lot for your answer!!
What language are you using? As that question may be better suited in the appropriate forum. If you are using PHP, are you utilizing PDO, MySQLi, MySQL?
Sorry, I am using PHP and MySQL.
Thanks a lot!
Okay, well then you can utilize several different options.
mysql_ fetch_ array, mysql_ fetch_ assoc, and mysql_fetch_row
All of the above options have examples of how to use them.
This topic is now closed. New replies are no longer allowed.