Hi guyz, i'm aiming for a php and My SQL dabase website, can anybody guide me plz?

appreciate the help

Hey.

Have you searched online for tutorials? There are probably hundreds of PHP/MySQL tutorials available online.

I always liked the one at w3schools.com.

The tutorials are fine if you want something quick (and possibly dirty!). You'll probably benefit more from buying a book on "php5 and MySQL 5". There are loads of good books out there, but an unbelievably large number of poor online tutorials. Books are usually peer-reviewed, but any idiot (including myself) can write a tutorial and post it online.

In my experience, books are essential for the "basics", whereas online resources tend to be good for "quirky" or "experimental/cutting-edge" stuff - but only if you know what's going on.

I'd suggest learning the basics before jumping in with both feet and incorporating free online scripts. Being a "script bunny" will end in tears - your SQL statements will be full of security holes and your php will be pure spaghetti.

O'Reilly usually have good resources as well as Wrox (think they've died recently?). Although a boring subject, security is an essential aspect of learning the basics - XSS/sql injections etc. You won't believe how many tutorials I've read or scripts I've seen that don't pay the slightest attention to security.

BTW: Atli is right, as far as it goes, W3Schools is a decent resource.

Happy hunting.

thanx guyz, i'm nt a complete nobie, i have basic PHP knowledge.

So why the q?

Dear ardav, i asked bcoz i want to start designing my own CMS in PHP, that's why i was wondering what does it need to start designing my own CMS.

regardz

Well I'm a starter too, but I did my own cms, and has a lot of features!

Depending on what site it is, i can help you:
I can help you with the User Authentication/Login System, Admin Panel with User Managment, Comments etc...

yes please.........i'll appreciate it

Ah, I see. In order to make a good CMS, get a good wysiwyg editor (or write your own - not for the faint-hearted!). Spaw2, Yahoo, TinyMCE, FCKeditor etc etc. These have a good solid user base with good support. Your DB design will be the key area for your development. You'll need to identify your static elements from your variable ones and ensure that they are placed in separate tables (unless using templates).

ya, i know about editors, i have no problem, can u clarify it more please, i'm not using any template engine like Rain TPL or any other, so what do u mean by:

"You'll need to identify your static elements from your variable ones and ensure that they are placed in separate tables (unless using templates)."