Project Detail

Description

Hello,

I am seeking af developer for a small stock system. This is a really simple system actually.

It requires a mysql db with 7 columns.

ID
art1
art2
stock
price1
price2
price3

The site to use this db should contain of two different functions.

Function 1.
an input box where I can enter the art1 number. If it exists already the function should return the actual product with the possibillity to alter the stock amount and prices and the save the new data.

If the product doesnt exist if should create a new product. The creation exist of some simple steps. First I should enter the art1 number. Then I would have to choose a letter D, H or A. Depending on which letter choosen it should return with the next number in this serie and insert it into art2. Example. If choosing H and last insertment was H103 it should insert H104 and so on. Afterwards I should have the possibility to enter the different amounts for the remaining fields.

Function 2.
I should have a possibility to enter a number from from art2 and then get it displayed on the site, whereafter I have the possibillity to alter the informations and store them.. It would be brilliant if It could show a little 125x125 picture too. All pictures are uploaded through ftp so no need of an upload function. All picture names are the same as art2.

This should actually be quiet simple I guess? hope that it makes a little sense :)