FROM Store_Information si
JOIN Geography AS geo
ON geo.id = si.id
WHERE si.name LIKE "%' . $find1 . '%"'
if you join on the id columns, you are making an error
that would match Los Angeles with "East, Louisiana Territory"
it would also match Los Angeles with "West, Florida"
so clearly, that approach won't work
you need a foreign key