i was wondering if this query was right
PHP Code:
$getentries= $DB_site->query("SELECT journal_entries.entrytext,journal_entries.entrytitle,journal_entries.entrydate,journal_entries.entry_totalrating AS totalrating,journal_entries.entry_totalvotes AS totalvotes,journal_entries.entry_id,journal_entries.journal_id,journals.journalist,journals.journalist_id,journals.journalname FROM ".TABLE_PREFIX."journal_entries LEFT JOIN ".TABLE_PREFIX."journals ON (journal_entries.journal_id=journals.journal_id) WHERE journal_entries.entry_active=1,journal_entries.private!=1,journal_entries.entrytext LIKE '%".$searchterm."%',journal_entries.entrytitle LIKE '%".$searchterm."%'");