I am looking for a place where I can learn properly, not just some sort of: practise using things like blah blah blah...

I want a TUTORIAL, to learn how to make Php things and with Mysql some of the way.

Also, I would appreciate somebody giving me a tutorial on how I can make an option for people on my website to make an account with a password.
Along with a code for people cna only acces certain pages if their account is logged in.

Try the zend website for some nice tutorials - http://www.zend.com/zend/tut/index.php

www.w3schools.com

also, check out your local library

w3schools is excellent article site for web stuffs. I think you should also visit this tutorial site http://hotwired.lycos.com/webmonkey/99/21/index2a.html. It will be helpful definately.

The first time I ever really made a real useful, in-depth script, I followed this tutorial:
http://biorust.com/index.php?page=tu...tail&tutid=115
It is how to make a full membership system with many usefull functions. After reading through it twice, I was able to adapt it, and pretty much re-code a whole new script which was similar to it, but IMO, more advanced.