Any Help fixing this error $query3 = "SELECT * from hidden WHERE USERID = '".mysql_real_escape_string($_SESSION['USERID'])."'"; $executequery3 = $conn->Execute($query3); $hidden = $executequery3->getrows(); $query2 = "SELECT A.*, B.seo, C.*, D.PID from Table1 A, Table2 B, Table3 C, hidden D where A.active='1' AND A.category=B.CATID AND A.USERID=C.USERID AND D.PID!=$hidden.PID order by A.feat desc, limit $pagingstart, $config[items_per_page]"; PHP: Here is the error LOG details PHP Fatal error: Call to a member function getrows() on a non-object in /home/user/public_html/domain/file.php on line ...[where above code is stated] Code (markup): i want this as $query2 = "SELECT A.*, B.seo, C.*, D.PID from Table1 A, Table2 B, Table3 C, hidden D where A.active='1' AND A.category=B.CATID AND A.USERID=C.USERID AND D.PID!=A.PID order by A.feat desc, $dby limit $pagingstart, $config[items_per_page]"; PHP: the part D.PID!=A.PID PHP: works for every one even user loged in or not or this data is related to logedin user or anyone else and i want it as select D.PID from Row where "_$Session userid"=USERID PHP:
Well not sure what happened $query3 = "SELECT PID from hidden_new WHERE USERID = '".mysql_real_escape_string($_SESSION['USERID'])."'"; $executequery3 = $conn->Execute($query3); $hidden_new = $executequery3->fields['PID']; PHP: $query2 = "SELECT A.*, B.seo, C.* from Table1 A, categories B, members C where A.active='1' AND A.category=B.CATID AND A.USERID=C.USERID AND A.PID!='$hidden_new' order .."; PHP: called query3 results here in query2 as AND A.PID!='$hidden_new' PHP: above code worked for me but i am still confused i used same above code for my old table "HIDDEN" but it gave the same error later i created a new table "hidden_new" and problem fixed