Member Avatar for Jay_H

how can i get value from following three table?.


1.In item table i want following field.
A.item_name
B.item_price
C.image_path
2.In orderdetail i want following field.
A.Quantity


* orderdetails field is like that

1.Orderdetail_id
2.Item_Id
3.order_id
4.amount
5.Quantity
6.status

Edited by Jay_H because: n/a
  • 2 Contributors
  • 1 Reply
  • 60 Views
  • 6 Hours Discussion Span
  • Latest Post Latest Post by tomato.pgn
Member Avatar for tomato.pgn

Use join to get records from 3 tables...For reference visit click here
PS-If your problem is solved mark the thread as solved

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.