When I add condition created_by = '@user_id' it work fine when showing data.
But when i searching with "All fields" condition (Just only "All fields" condition that issued wrong result)
Component showing incorrect data because OR
condition
This is MySQL Front end that I print.
SELECT id, created_by, title, hits FROM jos_content WHERE created_by = '62' AND UPPER(id) LIKE ('%0%') OR UPPER(created_by) LIKE ('%0%') OR UPPER(title) LIKE ('%0%') OR UPPER(hits) LIKE ('%0%') ORDER BY id asc LIMIT 0, 20
It's incorrect. The QUERY MUST HAVE bracket "( )" after Aditionnal Condition
The correct QUERY IS
SELECT id, created_by, title, hits FROM jos_content WHERE created_by = '62' AND (
UPPER(id) LIKE ('%0%') OR UPPER(created_by) LIKE ('%0%') OR UPPER(title) LIKE ('%0%') OR UPPER(hits) LIKE ('%0%') )
ORDER BY id asc LIMIT 0, 20
Im' try to fixs this .but Im' not find the place to add my bracket yet
Im' try to fixs this .but Im' not find the place to add my bracket yet
