phpLens
 home  products examples manual  faq support forum  contact news  login store

More Examples:   View Source:   Lookup Values

Free Download

  PHPLens
E Beg Prv Srch
(E) (e)Category (e)Product (e)Supplier (e)QuantityPerUnit (e)Stock (e)Price
76BeveragesLakkalikööriKarkki Oy500 ml
57
18.00
77CondimentsOriginal Frankfurter grüne SoßePlutzer Lebensmittelgroßmärkte AG12 boxes
32
13.00
 
(E)  
(e)ProductID76
(e)ProductLakkalikööri
(e)SupplierKarkki Oy
(e)CategoryBeverages
(e)QuantityPerUnit500 ml
(e)Price18.00
(e)Stock57
(e)UnitsOnOrder0
(e)ReorderLevel20
(e)Discontinued0
(e)Notes 
(e)OrderDate 
  PHPLens (Page 16)  
E Beg Prv 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