mysql - Php select from two tables not working correctly -
hello have 2 tables seo_settings | cat_id | cat_fullname | | 971 | catname 1 | | 443 | catname 2 | jcategories_to_hcategories | jcategory_id | hcategory_id | | 1 | 971 | | 2 | 443 | | 3 | 443 | and want cat_fullname category id i using $catids = array(1,2,3) foreach($catids $catid) { $sql3 = mysql_query("select a.cat_fullname seo_settings a, jcategories_to_hcategories b a.cat_id = b.hcategory_id , b.jcategory_id = $catid "); $data3 = mysql_fetch_array($sql3); } but $data3 return booleanfalse important there rows , connected correctly assume there problem in sql probably. try this $catids = array(1,2,3); $query = " select a.cat_fullname seo_settings left join jcategories_to_hcategories b on jcategories_to_hcategories b b.jcategory_id in (".implode(",", $catids).") "; $sql3 = mysql_query($query) or die(mysql_error()); while($data3 = m...