mysql PDO UPDATE colours SET colour=:colour WHERE colour=:colour not working

This is my php code

all my queries work but when I update a table with value where the value is the same it does not update. Should be an easy one for someone familiar with this problem. All help appreciated. thank you


View on Stack Overflow