DBVars.php

Summery       Transactions       Table       Old       Short
48 On Table      $1902.00 in Stock...Click for usage Notes

... To add a transaction, type "(#)-Name(recorded price)-From-To-(this price)-(notes)"
... The shortcuts are "W B I D P"
... To add a new product type "Name-a-a-Price (group)"
... To start timing a sculpture type "start"
... Multiple Transactions can be seperated by an *
... Typing just "($) Name(Price)" becomes Sale from Display at full price
... Description Words Can be used instead. They Are typed without spaces each character is checked

Show/Hide Table options
Show retired?
Base this table on data from:
too
Use only data from this Venue :

dates should be formatted like : 2009-10-04 24:59:59

Name

Price

Material
Cost

Display
Count

Invent.
Count

Backup
Count

Name
 

 

 
Stock
Value

Other
Sales

Out
of Blue

Sale
Count

View
Fail

Name
 

 
$/10
sales

Make
Time

$.per
Min

Earnings
Ready 4

MaxStock?
MinDisplay?
Group
Name

1) PineappleBouncing (1515) $0.00   72.857   1   9 01) PineappleBouncing (1515) $3.98 0.00 0.00 0.00
2) PineappleBrass (1405) $0.00   38.674   2   65 02) PineappleBrass (1405) $7.50 12.50 2.32 0.00
3) PineappleCopper (1359) $0.00   41.048   1   37 03) PineappleCopper (1359) $7.06 12.00 2.42 0.00
4) PineappleEarrings (1626) $0.00   57.667   0   4 04) PineappleEarrings (1626) $4.16 0.00 0.00 0.00
5) PineappleGoldGilt (1379) $0.00   41.222   0   18 05) PineappleGoldGilt (1379) $7.04 11.33 2.56 0.00
6) PineappleGroup (1406) $0.00   0.000   0   0 06) PineappleGroup (1406) $0.00 0.00 0.00 0.00
Name
Price
Material
Cost
Display
Count
Invent.
Count
Backup
Count
Name
 
Stock
Value
Other
Sales
Out
of Blue
Sale
Count
View
Fail
Name
 
$/10
sales
Make
Time
$.per
Min
Earnings
Ready 4
MaxStock? MinDisplay? Group
Name
7) PineappleRose (1502) $0.00   44.250   0   4 07) PineappleRose (1502) $6.55 12.00 2.42 0.00

Description words
SELECT Link From Inventory WHERE ID = LIMIT 1 in summery php You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'LIMIT 1' at line 1