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
1CondimentsSirop d'érableForêts d'érables24 - 500 ml bottles
113
28.50
2ConfectionsTarte au sucreForêts d'érables48 pies
17
49.30
3Dairy ProductsRaclette CourdavaultGai pâturage5 kg pkg.
79
55.00
4Dairy ProductsCamembert PierrotGai pâturage15 - 300 g rounds
19
34.00
5SeafoodEscargots de BourgogneEscargots Nouveaux24 pieces
62
13.25
 
(E)  
(e)ProductID61
(e)ProductSirop d'érable
(e)SupplierForêts d'érables
(e)CategoryCondiments
(e)QuantityPerUnit24 - 500 ml bottles
(e)Price28.50
(e)Stock113
(e)UnitsOnOrder0
(e)ReorderLevel25
(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