I am currently using MySQL but I have been advised a number of times that I should be using PDO.

The problem is I dont understand what PDO is and how it is different to MySQL. If you had a code run on MySQL how would you change it to PDO?