kenbusby — 2012-04-16T17:20:56-04:00 — #1
I have a simple database for a non profit that collects used sports equipment. I need a MySQL query I can plug into phpMyAdmin that does the following-
Finds a specific ITEM (i.e. cleats) and CONDITION (i.e. used) then multiplies the QTY of each ITEM by its UNIT VALUE. Then I need to add all the results together for one total. Any help greatly appreciated!
r937 — 2012-04-16T18:49:53-04:00 — #2
the parts in red are contradictory
unless there are multiple items that all have a "cleats" type
best would be if you could do a SHOW CREATE TABLE for the table in question
kenbusby — 2012-04-17T16:59:46-04:00 — #3
There are multiple lines that have "cleats" as the item. I need to multiply the number of cleats by the unit cost. Once I do that for each line I need to add all the results together.
r937 — 2012-04-17T17:08:27-04:00 — #4
could you please do a SHOW CREATE TABLE for the table in question