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
1ConfectionsZaanse koekenZaanse Snoepfabriek10 - 4 oz boxes
36
9.50
2Grains/CerealsWimmers gute SemmelknödelPlutzer Lebensmittelgroßmärkte AG20 bags x 4 pieces
22
33.25
3CondimentsVegie-spreadPavlova, Ltd.15 - 625 g jars
24
43.90
4ConfectionsValkoinen suklaaKarkki Oy12 - 100 g bars
65
16.25
5ProduceUncle Bob's Organic Dried PearsGrandma Kelly's Homestead12 - 1 lb pkgs.
15
30.00
 
(E)  
(e)ProductID47
(e)ProductZaanse koeken
(e)SupplierZaanse Snoepfabriek
(e)CategoryConfections
(e)QuantityPerUnit10 - 4 oz boxes
(e)Price9.50
(e)Stock36
(e)UnitsOnOrder0
(e)ReorderLevel0
(e)Discontinued0
(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