how to connect the html doc to microsoft sql database?

[twinkie]

how do you connect the html document to the microsoft sql database? i am using microsoft sql server 2000,by the way. can someone tell me?

[penagate]

You can't 'connect' a HTML document to a database. HTML is simply a document format.

If you want to produce HTML reports from a database, you will need to use a programming language. If this is to be done in a web-based environment, you will need to use a server-side technology such as PHP or ASP.NET (depending on your server's operating system).

[twinkie]

that means if i have a php document, then it will be possible for me to connect the document to database, is it?

what i know is that, php code is embedded with the html code. i save the document under .html extension. so, what should i do so that the document can be connected to the database?

[techgnome]

well, for starters, not saving it with the HTML extension. That jsut makes it a plain HTML document, and will be rendered by the browser, to include all the PHP code. If you are trying to use PHP, then you need to save the file with a PHP extension. Additionaly, it's only going to work if PHP is installed on the web server you are using.

-tg

[mendhak]

http://uk.php.net/function.mssql-connect