require("../dc/defines.php"); $con = mysql_connect(defhost,defusername,defpassword); mysql_select_db(defdatabase); $SQL = selectfrom . experiencetable . cmm . producttable . where . experiencestatus . eq . "1" . a__ . producttable . pnt . productid . eq . experiencetable . pnt . experienceproductid; $query = mysql_query($SQL); $result = array(); while ( $r = mysql_fetch_array($query,MYSQL_ASSOC) ){ array_push($result,$r); } mysql_close($con); ?>