say we got 3 tables
/clients/
id
name
category
/items/
id
name
price
category
/orders/
id
customerid
itemid
quantity
i want to archive a simple page where once i select a customer in a dropdown menu i get a display of all items that belong into said category
that should look like this
==========================================
-----------------------------------
client: HONDA
-----------------------------------
/QUANTITY/ /ITEM/
□ -MOTOR v8
□ -MOTOR v6
□ -MOTOR v6-A
==========================================
now i know that i can select items and add them one by one as shown in the demo 1:
http://xlinesoft.com/livedemo/phprunner/livedemo1/orders_add.php
however far more easy to just select a category and just add the orders from there.
so far i have used this guide:
https://xlinesoft.com/phprunner/docs/select_multiple_values.htm
but i cannot put quantites to the items. you can check progress here:
http://www.bodegadelibros.com.mx/mayoreo/ordenes_add.php