When running that query using PHP, I now get all results from table A returned, no matter what I type into the search.
When running the following query in navicat:
sql code:
SELECT a.*, b.name FROM upgrades AS a INNER JOIN zm_timetracker AS b ON a.steamid = b.steamid WHERE b.name LIKE '%cherry%'
I get 4 results returned, with all their corresponding fields in TableA, and all of which have "cherry" in their name in tableB.
EDIT: Forget that, I found what I did wrong. Thank you so much everyone for your help