is this query right?

[AN-net]

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."%'"); 


[Modin]

Looks ok to me, though I don't believe you need to explicitly specify the join in mysql...though specifying it doesn't do any harm

ie. you could do something similar to...

SELECT * FROM journal_entries, journal WHERE journal_entries.journal_id = journal.journal_id etc....

Your query looks fine, mine is just easier to write