database for stock
 

This is a general Q. I have got a small stock load that comes in and goes out. I have got a member of staff to sort out some sort of spread sheet, but its hard to see what we have got in stock and what is out.

Is there something that we can use like a DB (mysql or openoffice database) that we can type in what is in and what is out. It dosen't have to be flashy simple is nice.

I nice to have would be some sort of back up. some sort of user access control (reader or admin)

Any help would be nice.

This sounds like you're looking for an inventory application? If so, a combination of MySQL and PHP might just work for you -- Google for "linux php inventory" and there are quite a few (well, millions) of possibilities and it might be worth looking through the first couple of pages to see what's available.

Broadly, you'd probably want to have an inventory system built in a data base management system (that would be MySQL) with an interactive front end (that would be PHP) to view and alter the information in the data base's tables; you want PHP so you can have browser-based forms to view and alter information.

Take a look and see if something fits your needs.

thanks for the post i have been looking around to find something that looks like its a gower.
I have got
Apache2
PHP
mysql
all running, the problem i have now is that i need Perl.

How do i install that as i have had a look about the docs for ubuntu and can not find it?

Perl comes usually with base system, no need to install it. :)

i have found (what looks like) a better tracker, but i am getting problems with the install.

This is the install page

http://sourceforge.net/projects/asset-tracker/

i have followed the install txt file but all i get is .............

Warning: mysql_connect() [function.mysql-connect]: Access denied for user 'www-data'@'localhost' (using password: NO) in /var/www/asset-tracker/wwwroot/functions/variables.php on line 184

Warning: mysql_select_db(): supplied argument is not a valid MySQL-Link resource in /var/www/asset-tracker/wwwroot/functions/variables.php on line 185

Warning: mysql_query() [function.mysql-query]: Access denied for user 'www-data'@'localhost' (using password: NO) in /var/www/asset-tracker/wwwroot/functions/sql.php on line 460

Warning: mysql_query() [function.mysql-query]: A link to the server could not be established in /var/www/asset-tracker/wwwroot/functions/sql.php on line 460

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /var/www/asset-tracker/wwwroot/functions/display.php on line 112

Warning: mysql_query() [function.mysql-query]: Access denied for user 'www-data'@'localhost' (using password: NO) in /var/www/asset-tracker/wwwroot/functions/sql.php on line 460

Warning: mysql_query() [function.mysql-query]: A link to the server could not be established in /var/www/asset-tracker/wwwroot/functions/sql.php on line 460

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /var/www/asset-tracker/wwwroot/functions/display.php on line 120

Warning: mysql_query() [function.mysql-query]: Access denied for user 'www-data'@'localhost' (using password: NO) in /var/www/asset-tracker/wwwroot/functions/sql.php on line 460

Warning: mysql_query() [function.mysql-query]: A link to the server could not be established in /var/www/asset-tracker/wwwroot/functions/sql.php on line 460

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /var/www/asset-tracker/wwwroot/functions/display.php on line 128

Warning: mysql_query() [function.mysql-query]: Access denied for user 'www-data'@'localhost' (using password: NO) in /var/www/asset-tracker/wwwroot/functions/sql.php on line 460

Warning: mysql_query() [function.mysql-query]: A link to the server could not be established in /var/www/asset-tracker/wwwroot/functions/sql.php on line 460

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /var/www/asset-tracker/wwwroot/functions/display.php on line 136

Warning: mysql_query() [function.mysql-query]: Access denied for user 'www-data'@'localhost' (using password: NO) in /var/www/asset-tracker/wwwroot/functions/sql.php on line 460

Warning: mysql_query() [function.mysql-query]: A link to the server could not be established in /var/www/asset-tracker/wwwroot/functions/sql.php on line 460

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /var/www/asset-tracker/wwwroot/functions/display.php on line 144

Warning: mysql_query() [function.mysql-query]: Access denied for user 'www-data'@'localhost' (using password: NO) in /var/www/asset-tracker/wwwroot/functions/sql.php on line 460

Warning: mysql_query() [function.mysql-query]: A link to the server could not be established in /var/www/asset-tracker/wwwroot/functions/sql.php on line 460

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /var/www/asset-tracker/wwwroot/functions/display.php on line 152
go to page: main
logged in as:

Warning: mysql_query() [function.mysql-query]: Access denied for user 'www-data'@'localhost' (using password: NO) in /var/www/asset-tracker/wwwroot/functions/sql.php on line 460

Warning: mysql_query() [function.mysql-query]: A link to the server could not be established in /var/www/asset-tracker/wwwroot/functions/sql.php on line 460

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /var/www/asset-tracker/wwwroot/functions/sql.php on line 209

No "view assets" permission allowed

Warning: mysql_query() [function.mysql-query]: Access denied for user 'www-data'@'localhost' (using password: NO) in /var/www/asset-tracker/wwwroot/functions/sql.php on line 460

Warning: mysql_query() [function.mysql-query]: A link to the server could not be established in /var/www/asset-tracker/wwwroot/functions/sql.php on line 460

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /var/www/asset-tracker/wwwroot/functions/sql.php on line 209

No "add assets" permission allowed

Warning: mysql_query() [function.mysql-query]: Access denied for user 'www-data'@'localhost' (using password: NO) in /var/www/asset-tracker/wwwroot/functions/sql.php on line 460

Warning: mysql_query() [function.mysql-query]: A link to the server could not be established in /var/www/asset-tracker/wwwroot/functions/sql.php on line 460

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /var/www/asset-tracker/wwwroot/functions/sql.php on line 209

No "modify assets structure" permission allowed

I have looked at the PHP file to make sure that all the information is in there, but im not up to speed with what should / shouldn't be in there.

I have not got it all up and running. its a very good system, some lacking in backups/restores and the passwords are not working.

its "ronsil" dose what it said on the tin