Web Development

You didn't mention your preferred platform, but if you are willing to entertain using a Linux or FreeBSD web server, I'm a big fan of using the MySQL database with PHP code to access it. The combination of Apache, MySQL and PHP works pretty well together and the price is right. Plus, they are all open-source and there are some really active newsgroups and mailing lists to provide support.

You might also want to look at one of the many Linux-based e-commerce packages because you might find something that is already set up as an on-line catalog that would do precisely what you need without much coding.

regards!

paul

Well if the query is really that simple, and the amount of data is not huge, i'd use a flat file system, there would be two pages.
First an HTML page with a form for you to enter product id, minimally:
<form action="query.pl">
<input name="id">
<input type="submit">

second page, a perl/cgi script, searches a text file for the correct record:
$query->new CGI;
$id=$query->param("id");
open(iFILE,'< database.txt');
while(<iFILE>){
@record=split(/\|/,$_);
if($record[0] eq $id){
last;}}

Just out put the @record array in the correct layout.

The flat file would look like this:
id|field1|field2| ...

If you want more details on the code, just send an email.

There are many technologies which u can use to access database via web. You want to program HTML forms interacting with databases. I am aware of these technologies, which u can consider to use -
1. ASP (Active Server Pages) : You can use any ODBC compliant database on NT Server with ASP. I am doubtful if any unix flavour of ASP exists.
2. Java Servlets : You can use Servlets to interact with databases. You can access databases with ODBC drivers as well propritary drivers provided by DB vendors and 3rd parties also like Weblogic. There are actually 4 kinds of DB drivers u can use with JDBC(Java Database Connectivity) through servlets. You can read details if u want servlets to power ur web site.
3. PHP : You can use PHP with databases like MySQL, or any ODBC compliant database like Oracle, SQL Server, Access, DB2 etc.
4. Perl/CGI : You can use databases with Perl scripts.
5. Coldfusion : You can use databases with Coldfusion scripts.
6. JSP (Java Server Pages) : You can use JSP which is very similar

(contd .. )
6. JSP (Java Server Pages) : You can use JSP which is very similar to ASP in programming to interact with databases via web.

There may be few more options for web based database access. Along with the above technologies u would need a m/c connected to Internet running web server, so that anybody on Internet can access ur site.

Hope my answer helps u.

regards
-mukul

You can use Free ASP application. Visit http://www.aspcode.net/products/prodmentor/

It is a simple web-based / database-driven product catalog.