This is so unfair,im 6 months in php,and now everyone come and tell me that mysql wont work soon,so i have to choose between pdo or mysqli,so its like i wasted half a year learning php for nothing 
Is there anyone who would change my website to mysqli for free?Just asking.
I wouldn’t say you wasted anytime, Learning sql is still learning sql that hasn’t changed. You just need to change they way you access the sql and display it.
I think you are mistaking, mysqli and pdo are not something else than PHP, they are resources >in< PHP.
Just change the way you run your SQL queries and you’re good to go. Read up on my PDO tutorial for a very simple way of handling SQL in PHP.
This is a bit of a negative outlook on things. The first rule in technology is to keep yourself up-to-date. There are not a huge amount of changes between 5.2 and 5.4. (Can I depress you even further and say that 5.6 Alpha has just been released?)
You see, times change, so do things. TopCoder and JimL, do you remember writing websites in HTML using tables? Ha! Took me months to learn CSS and that was before I started to learn PHP & MySQL.
As a developer though, do you not want to make sure that your systems are up-to-date? I don’t believe a system is ever complete to be honest, times and standards change, if you can’t adapt to the environment around you, what hope have you got?
Thx,your comments motivated me =)