Information générale
Catégorie:
Codage, syntaxe et commandes
Titre:
Save record frm 2 different tables
peace!!!
i have this product table and a purchase table.... im going to display all the products to a grid and im going to update the price and quantity of each product, then i have a "purchased by" information entry also. and im going to save the updated products and the "purchased info" to purchased table.
&& heres the table-purchased look like
purchased id name product quantity price
1101 joe apple 5 20
1101 joe mango 3 10
1101 joe banana 6 15
&& table-product
product_id product_name
p101 apple
p102 mango
p103 banana
&&& the entry form
_______________________________________________________________
purchased id: 1101
name : joe
&&& grid
_______________________________________________________________
product id product name quantity price
p101 apple ____ ____
p102 mango ____ ____
p103 banana ____ ____
_______________________________________________________________
is it possible to save all this information in one table? and how to do it?
thnx!!!
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement