website inventory database system

[ars727]

Hey I need your guys help on were to get started with this.
Basically this guy wants me to build him a site were he or his employee's can go on and update his inventory system from it. I would like something where they could go on and change certain values of it, create new inventory records, and delete the records. I already of experience with html, dreamweaver, and databases. I will be working off of a windows xp system.
Anyway any advice, websites I could visit to get help, or tools that would help me would be greatly appreciated

Thanks,
Andy

[revelation]

I know that some here will disagree with me here. If you have experience with html and databases then you could use Frontpage and Access. If you are already using Windows, then it should work well and would not even cost that much.

That being said, there must be a good way to do the same thing with Dreamweaver. It is a better program than Frontpage and you are already familiar with it.

[james8547]

I'd say MySQL and PHP will accomplish that task easy.

[mairving]

Originally posted by james8547
I'd say MySQL and PHP will accomplish that task easy.
Easily if you know how to write PHP/SQL.

You might look over at HotScripts (http://www.hotscripts.com/PHP/Scripts_and_Programs/index.html) to see if there are any scripts that might work for you now. There is a ton of development out there for PHP/MySQL so you can get plenty of help if you decide to roll your own.

I really wouldn't use Access for a several reasons. One is that it is an awful database for the web. It can't handle concurrent connections well. MySQL, on the other hand, is a Hoss. It also requires you to be with a Windows host.

[doctorgonzo]

I think that you should go with what you know. I agree that MySQL and PHP would work best, but if you don't know them (and don't want to learn) then why go with them? Access 2000 and greater have support for Data Access Pages, which make designing webforms for database access pretty easy. Sure, Access is crappy when it comes to more than a few people using it at once, and it has a bunch of other problems as well, but if this system is going to be put on a company intranet where only two or three people will be using it at any one time, it should work.