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
1CondimentsChef Anton's Gumbo MixNew Orleans Cajun Delights36 boxes
0
21.35
2Meat/PoultryAlice MuttonsPavlova, Ltd.20 - 1 kg tins
0
39.00
3Meat/PoultryThüringer RostbratwurstPlutzer Lebensmittelgroßmärkte AG50 bags x 30 sausgs.
0
123.79
4Dairy ProductsGorgonzola TelinoFormaggi Fortini s.r.l.12 - 100 g pkgs
0
12.60
5Meat/PoultryPerth PastiesG'day, Mate48 pieces
0
32.80
 
(E)  
(e)ProductID5
(e)ProductChef Anton's Gumbo Mix
(e)SupplierNew Orleans Cajun Delights
(e)CategoryCondiments
(e)QuantityPerUnit36 boxes
(e)Price21.35
(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