Skip navigation links

MySQL Forums :: PHP :: Returing multiple rows based on 2 criteria


Advanced Search

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


Subject Written By Posted
Returing multiple rows based on 2 criteria chris d 12/09/2012 07:04PM
Re: Returing multiple rows based on 2 criteria Barry Galbraith 12/09/2012 08:43PM
Re: Returing multiple rows based on 2 criteria chris d 12/09/2012 10:17PM
Re: Returing multiple rows based on 2 criteria Barry Galbraith 12/09/2012 10:29PM
Re: Returing multiple rows based on 2 criteria chris d 12/09/2012 10:36PM
Re: Returing multiple rows based on 2 criteria Barry Galbraith 12/09/2012 10:56PM
Re: Returing multiple rows based on 2 criteria chris d 12/09/2012 11:03PM
Re: Returing multiple rows based on 2 criteria Barry Galbraith 12/09/2012 11:06PM
Re: Returing multiple rows based on 2 criteria chris d 12/09/2012 11:08PM
Re: Returing multiple rows based on 2 criteria chris d 12/10/2012 01:46PM
Re: Returing multiple rows based on 2 criteria Barry Galbraith 12/10/2012 03:08PM
Re: Returing multiple rows based on 2 criteria chris d 12/10/2012 03:28PM
Re: Returing multiple rows based on 2 criteria Barry Galbraith 12/10/2012 06:37PM


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.