MySQL Forums
Forum List  »  PHP

Returing multiple rows based on 2 criteria
Posted by: chris d
Date: December 09, 2012 07:04PM

Hey guys,

For my senior project, im making a web app for deli food orders. This consists of a database containing the following tables:

customer PK custID
inventory PK inventoryID
item PK itemID
item_type PK itemTypeID
order PK orderID
order_line PK orderLineID PK FK orderID

So basically theres a M-M relationship between the table ORDER and ITEM. The conjoining table is ORDER_LINE.

I want to be able to RETURN each consecutive row in ORDER_LINE that belongs to a particular orderID.

Thanks in advance!

Options: ReplyQuote

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.