phpLens
 home  products examples manual  faq support forum  contact news  login store

More Examples:   View Source:   Lookup Values

Free Download

  PHPLens
E Nxt End Srch
(E) (e)Category (e)Product (e)Supplier (e)QuantityPerUnit (e)Stock (e)Price
1Meat/PoultryAlice MuttonsPavlova, Ltd.20 - 1 kg tins
0
39.00
2SeafoodBoston Crab MeatNew England Seafood Cannery24 - 4 oz tins
123
18.40
3Dairy ProductsCamembert PierrotGai p√Ęturage15 - 300 g rounds
19
34.00
4SeafoodCarnarvon TigersPavlova, Ltd.16 kg pkg.
42
62.50
5BeveragesChangieGrandma Kelly's Homestead24 - 12 oz bottles
17
0.00
 
(E)  
(e)ProductID17
(e)ProductAlice Muttons
(e)SupplierPavlova, Ltd.
(e)CategoryMeat/Poultry
(e)QuantityPerUnit20 - 1 kg tins
(e)Price39.00
(e)Stock0
(e)UnitsOnOrder0
(e)ReorderLevel0
(e)Discontinued1
(e)Notes 
(e)OrderDate 
  PHPLens (Page 1)  
E Nxt End Srch

Notes

Show how lookups work. In this case,
  • CATEGORYID is a lookup based on select categoryid,categoryname from categories.
  • SUPPLIERID is a lookup using select supplierid,companyname from suppliers.
email: contact#phplens.com (change # to @)     telephone (malaysia): 60-3-7947 2888     fax (malaysia): 60-3-7947 2800