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
1Dairy ProductsQueso CabralesCooperativa de Quesos 'Las Cabras'1 kg pkg.
25
21.00
2SeafoodNord-Ost MatjesheringNord-Ost-Fisch Handelsgesellschaft mbH10 - 200 g glasses
10
25.89
3ConfectionsZaanse koekenZaanse Snoepfabriek10 - 4 oz boxes
36
9.50
4Dairy ProductsQueso Manchego La PastoraCooperativa de Quesos 'Las Cabras'10 - 500 g pkgs.
86
38.00
5Dairy ProductsFl√łtemysostNorske Meierier10 - 500 g pkgs.
26
21.50
 
(E)  
(e)ProductID11
(e)ProductQueso Cabrales
(e)SupplierCooperativa de Quesos 'Las Cabras'
(e)CategoryDairy Products
(e)QuantityPerUnit1 kg pkg.
(e)Price21.00
(e)Stock25
(e)UnitsOnOrder35
(e)ReorderLevel35
(e)Discontinued0
(e)Notes 
(e)OrderDate03-Jun-2011
  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