MySQL Forums
Forum List  »  Newbie

Re: joined query problem
Posted by: vishal barot
Date: May 12, 2010 07:55AM

hi there..

i think u can't do this in single query..

if u can it in single query its gr8....

in a single query i cant do that

if u r using php then first u can do this like :

$qry=mysql_query(" select price_cat_id from price_cat ");


$pro_qry =mysql_query("select * from price where price_pricecat = ".$result["price_cat_id"]."")


like this......

Options: ReplyQuote

Written By
May 12, 2010 05:21AM
Re: joined query problem
May 12, 2010 07:55AM
May 12, 2010 08:08AM
May 12, 2010 08:26AM

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.