I'm trying to do two queries, does this code look right? bchocitation is a table that holds information about citations we are using. Ultimately I want a list of all citations that are not linked to. My plan was to get the list of citation titles, and compare them against titles in pagelinks, if the title does not appear in pagelinks then it isn't linked to.
//SELECT page_title FROM bchocitation, page WHERE bchocitation.page_id=page.page_id; $results = array(); $dbr =& wfGetDB( DB_SLAVE ); $res = $dbr->select( array( 'bchocitation', 'page'), //from 'page_title', //select array('bchocitation.page_id'=>'page.page_id'),//where __METHOD__, array() //extras ); while ($obj = $dbr->fetchObject($res)) { $results[] = $obj; } $dbr->freeResult($res); //SELECT pl_title FROM pagelinks WHERE pl_title='$title'; $result = ""; $dbr =& wfGetDB( DB_SLAVE ); $res = $dbr->select( 'pagelinks', //from 'pl_title', //select array('pl_title'=>"'$title'"),//where __METHOD__, array() //extras ); while ($obj = $dbr->fetchObject($res)) { $result = $obj; } $dbr->freeResult($res);
Any help is much appreciated! -Courtney Christensen