• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 144
  • Last Modified:

a guidance needed in the following code

i have a following screenshot, whereas in one form, i need to add the products for single invoice and i can add multiple products.

I can create the new products and price easily, i am facing issue during insert/update, i am doing an insert into two tables rather in one. one for products and other for the invoice so 1 invoice can have n products,

i am having some issues in CRUD, need a bit of guidance in this

i know this will be asked [what you have done so far], honestly nothing, i need fresh idea where i should go ahead
color.bmp
0
Gurpreet Singh Randhawa
Asked:
Gurpreet Singh Randhawa
  • 2
1 Solution
 
stu215Commented:
What kind of problem are you having? Error?

- when you submit the form it should do 2 inserts, one into the header table and the other should loop over line items ( name, qty, price )...?  then return to a printable invoice page?
0
 
Gurpreet Singh RandhawaWeb DeveloperAuthor Commented:
i solved it
0
 
Gurpreet Singh RandhawaWeb DeveloperAuthor Commented:
Solved by adding a different set to the post
0

Featured Post

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now