Hi,
I am a registered user of PHP 8.1
I have two tables namely "Products" and "Current Stock"
Table Product has following main attributes:
Qty
Part No
Type
Model
Manufacturer
Description
Grade
Warranty
Location
Everything seems to be working perfect except for the following that I can't seem to figure out:
I want similar products with different quantities to be shown as a total in stock table. For example I have "E207WF" LCD that is stored on three pallets each pallet has different quantity (Pallet one 36, Pallet 2 36, Pallet 3 14). What should I do that on display page and search result page it sums up quantity of similar product as one total.
Can anyone please help me set up this query?
Regards
Awais