Hi, I am trying to create an online inventory for customers to view product details.

Customers
They will be presented with "current promotions" on the front page. And will be able to search for products using keywords. And arrange them according to price, name, etc...
All the infomations of the products will be stored with MySQL.

Staff
Staff can login and edit product details(upload pix, etc...), create new product details through the internet. Staff's action will be logged in a text file.

I was thinking of using JSP and MySQL to do it. Or would PHP be a better choice?

And where can I access codes similar to the search results of Amazon? Click on a product and goes into the product details page. Are these page created dynamically?

And where can I access codes to rearrange search results?

Can someone teach me how to do the event logging? Or what other security measures should I implement?

sounds like a shopping cart type of program.
i think PHP would be easier, but i havent tried JSP before, so dunno.

try here...
http://www.hotscripts.com