PDO passing bool values rather than the bind values

I’m trying to add an entry into a table if it doesnt exist of update it if it does exist. $sql = "INSERT INTO company (userid, companyName, registeredAddress, registeredPostcode) VALUES ($userid, companyName = :companyName, registeredAddress = :registeredAddress, registeredPostcode = :registeredPostcode) ON DUPLICATE KEY UPDATE companyName = :companyName, registeredAddress = :registeredAddress, registeredPostcode = :registeredPostcode;"; $stmt = … Read more