MySQL Forums
Forum List  »  Newbie

Re: joined query problem
Posted by: Tivadar Tot
Date: May 12, 2010 08:08AM

Vishal, Youre great, its work, thank You wery much!!!

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

while($result=mysql_fetch_assoc($qry)){

echo $result['price_cat_name_hu'] . '<br />';

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

while($result1=mysql_fetch_array($pro_qry)) {

echo $result1['price_name_hu'] . '<br />';
}

}

Options: ReplyQuote


Subject
Written By
Posted
May 12, 2010 05:21AM
May 12, 2010 07:55AM
Re: joined query problem
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.