Dug myself a hole! And i can't get out of it.

Can any of you lovely people offer some advice.

I have to build a website. I have a domain name and web hosting sorted.

I have frontpage 2000.
Dreamweaver4
Access2000
VB6
MySQL

My dilema is what to write my web site in. I tried in frontpage but my hosting site says they do not support FP extentions but does this matter i don't know.

If i do it in dreamweaver4 can i use access or mySQL as i have checked it out and appears that i can't just create a database like in FP as i don't have dreamweaverMX and can't afford it. Does any one know what i should do and what to use. I checked out a few sites for advise and PHP and mySQL seem to be a good match but isnt PHP just another scripting language.

I know what i have to do (me thinks!) but how should i do it is the question. what should i use with what. My hosting also has myphpadmin but not sure what that is yet.

If i create databases manually in mySQL how do i get them into Dreamweaver or do i just create the table and then save it somewhere and then write some SQL inserts and updates etc in my HTML code in Dreamweaver.

few got that off my chest, has anyone got any suggestions for any of these issues as i would be so greatful.
Charmaine
P :confused: :confused: :confused: :confused:

I have no idea how to use vb6 on the net, or mysql. But I have my own webserver set up at home, and I use notepad, or front page, if I'm in a hurry. I find notepad's best, frontpage sticks in bits of code that you don't need, it messes up my tables, and javascript.

I haven't tried any of the others, I'm sorry I couldn't give you more advice.

Okay so if i use notepad and fp to do all my code how do i link the database stuff. Where do i create my tables so no one can see them and what kind of code do i use to say create a user registration form, login and then display their details on my pages.

Charmaine

Okay i have created a database in mySQl and my hosting site will allow me to upload the database. So in my HTML code do i just say insert into table or what this is the bit i am unsure of does anyone know of some examples.

You can't have a database driven site using basic HTML you'll have to use a server side language such as ASP.

edit - Just noticed you mentioned PHP (server-side language) and yes it works very well with mySQL.

Could i creat my site in dreamweaver and add PHP code in that which links to my SQL, is that possible and PHP is just a language. I have checked out some sample code and this guy wrote a whole website using PHP4.0 and Mysql but dont understand what he wrote the PHP in. There is a dreamweaver template amongst the files though.

Right I think you are getting a bit confused...

Dreamweaver and frontpage are editors not languages. To write HTML and/or ASP and/or PHP you do not need these. You could use notepad instead even. However these editors (particularly Dreamweaver) can make your life much easier.

If you are wanting to run a website off a database (in your case mySQL) you need a server-side language that has access to the database. In your case it sounds like PHP is obvious option.

The server-side scripting language builds the HTML that is output to the user in the browser.

Therefore from this I would suggest you look up as much about PHP as possible.

Hope that helps

DJ