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
1BeveragesLEOExotic Liquids10 boxes x 20 bags
39
18.00
2CondimentsProducto, superExotic Liquids12 - 550 ml bottles
13
10.12
3CondimentsChef Anton's Cajun SeasoningNew Orleans Cajun Delights48 - 6 oz jars
53
22.00
4CondimentsChef Anton's Gumbo MixNew Orleans Cajun Delights36 boxes
0
21.35
5CondimentsLouisiana Fiery Hot Pepper SauceNew Orleans Cajun Delights32 - 8 oz bottles
76
21.05
  
(E)  
(e)ProductID1
(e)ProductLEO
(e)SupplierExotic Liquids
(e)CategoryBeverages
(e)QuantityPerUnit10 boxes x 20 bags
(e)Price18.00
(e)Stock39
(e)UnitsOnOrder0
(e)ReorderLevel10
(e)Discontinued0
(e)Notes 
(e)OrderDate01-Feb-2003
  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