home  products examples manual  faq support forum  contact news  login store

More Examples:   View Source:   Lookup Values

Free Download

This is a Demo. You can not change anything for security reasons.
Back to Grid     phpLens Settings   Choose   Generate PHP Code   Remove All Settings   ?  
IndexColumn NameActual TypePHPLens Type
1PRODUCTID int[11]R: Autonumber
2PRODUCTNAME string[120]C: Character
3SUPPLIERID int[11]I: Integer
4CATEGORYID int[11]I: Integer
5QUANTITYPERUNIT string[60]C: Character
6UNITPRICE real[22]N: Numeric
7UNITSINSTOCK int[11]I: Integer
8UNITSONORDER int[11]I: Integer
9REORDERLEVEL int[11]I: Integer
10DISCONTINUED int[1]I: Integer
11NOTES blob[196605]X: Text
12ORDERDATE date[10]D: Date


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: (change # to @)     telephone (malaysia): 60-3-7947 2888     fax (malaysia): 60-3-7947 2800