LAMP reference materials??

[cdhgold]

I'm planning on building my first LAMP app have not written code since
c++ for DOS any good reference recommendations?

I need to
1) create the database
2) create the app

I have not done either of these before

[Void Main]

There really is nothing to it. If you are running a modern distro (Fedora for example) everything you need is already installed (or can be with a simple "yum install xxx"). Start the MySQL and httpd services and away you go. Connect to mysql and create your database, tables, and your user then create your PHP app. I don't know of any "one" good source other than plug your questions into google and away you go. Or plug your questions in here and I'll help you if you can wait for me to respond. Google is probably quicker.

Do I assume you already know SQL and HTML? If not then there are really 3 different things you need to learn and that is SQL, HTML and PHP. It's good to have a basic understanding of both SQL and HTML before you embark on building a database PHP app.

[cdhgold]

i do not know any of the above this is my 1st time to try any of them

[Void Main]

In that case the first thing I would learn is basic HTML because you will be writing PHP code that generates HTML for a user's web browser to interpret. Then I would learn the basics of PHP. That is how to write simple non-database PHP programs that generate HTML (assuming your app will be web based). Then move on to basic SQL using MySQL. Once you've done all that then tying it all together is fairly trivial.

[cdhgold]

recommended places to start reading?

[Void Main]

I would just start doing google searches for "HTML tutorial" and find some place that fits your liking. Here's one that looks like it might be a good place to start:

http://www.echoecho.com/html.htm

You don't have to learn everything about HTML but just understand the basic structure and then you'll use HTML references to check tag options, etc. Since you are going to be doing database work you'll want to be able to do basic HTML and you'll want to understand HTML forms and HTML tables.

Of course http://www.w3.org/ is where the HTML standards are published so it would be a good idea to browse that site. They even have HTML validator so you can put the URL of your page into the validator and it will check it out and tell you whether it follows standards and point out your errors if you have any and tell you how to fix them.

As a matter of fact w3 has tutorials right on their site:

Basic:
http://www.w3.org/MarkUp/Guide/

Advanced:
http://www.w3.org/MarkUp/Guide/Advanced.html

I personally use VIM to edit HTML and PHP. I really like it's color syntax highlighting among other things.