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
1SeafoodIkuraaTokyo Traders12 - 200 ml jars
31
31.00
2SeafoodKonbuMayumi's2 kg box
24
6.00
3SeafoodCarnarvon TigersPavlova, Ltd.16 kg pkg.
42
62.50
4SeafoodNord-Ost MatjesheringNord-Ost-Fisch Handelsgesellschaft mbH10 - 200 g glasses
10
25.89
5SeafoodInlagd SillSvensk Sjöföda AB24 - 250 g jars
112
19.00
 
(E)  
(e)ProductID10
(e)ProductIkuraa
(e)SupplierTokyo Traders
(e)CategorySeafood
(e)QuantityPerUnit12 - 200 ml jars
(e)Price31.00
(e)Stock31
(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