Member Avatar for hiiiiii@

hi im using to table members and orderitems,food_details

members table has the following fields
memebr_id
membername
food_details has the following fields
food_id
price
orderitems has fiels such as
order_id
member_id
food_id
quantity
price
total.
I need to insert member_id,food_id,foo_price from tables members,food_details into order_items table .how to achieve ?

  • 2 Contributors
  • 1 Reply
  • 117 Views
  • 24 Minutes Discussion Span
  • Latest Post Latest Post by milil
Member Avatar for milil

You need to write sql you need for that and you can make new page in php who will do that. On this link you have a pice of code that will insert user in table with username and password you can learn from that.

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.