Dynamic Search Query
This example processes the query from dbdemo5
It allows querying on any combination of VEN_STATE and VEN_CODE.
See the source
Notice: Undefined variable: VEN_CODE in /web/html/tutorial/htmlguid/php/dbdemo5a.phtml on line 20
Notice: Undefined variable: VEN_STATE in /web/html/tutorial/htmlguid/php/dbdemo5a.phtml on line 25
Notice: Undefined variable: VEN_STATE in /web/html/tutorial/htmlguid/php/dbdemo5a.phtml on line 26
SELECT VEN_CODE AS "VENDOR CODE", VEN_PH AS "VENDOR PHONE", VEN_CONTACT_NAME AS "CONTACT_PERSON", VEN_STATE AS "STATE" FROM CIS3311.VENDOR WHERE VEN_STATE = ''