peace!!!!

i would like to append all the products into the purchased table when i selected a category(product table).

for example:
joe selected a category; fruits. then all the fruits from the product table under the selected category shall append to the purchased table.and the purchase table will look like this(assuming that i already input the quantity and price or i already purchased)

>>>purc_id -- name --- prod_id --- prod_name --- quantity --- price &&fieldnames
>>>1001 ------joe--------p101--------apple--------3 pcs-------$10 &&records
>>>1001-------joe--------p102--------mango--------2 pcs-------$12
>>>1001-------joe--------p103--------orange-------2 pcs-------$10

is it possible and how?
thanx!!!


>>>>>>product table
category:
product_id:
product_name:

>>>>>purchased table
purc_id:
name:
prod_id:
prod_name:
quantity:
price: