In the UD4 tutorial regarding the advanced results page the full SQL statement is as follows:

SELECT EMPLOYEEID, LASTNAME, FIRSTNAME, DEPARTMENT, EXTENSIOIN FROM EMPLOYEES WHERE LASTNAME LIKE 'varLASTNAME' AND DEPARTMENT LIKE 'varDEPT'

This is the ASP/Access syntax... Can anybody help me out with the equivelent PHP/MYSQL statement?

Also What would be the runtime value?

eg: Request("txtLastName"
Request("mnuDept"

Thanks in advance <img src=../images/dmxzone/forum/icon_smile.gif border=0 align=middle>

Hello,

Here is the correct code for Php:

SELECT EMPLOYEEID, LASTNAME, FIRSTNAME, DEPARTMENT, EXTENSIOIN FROM EMPLOYEES WHERE LASTNAME LIKE 'varLASTNAME' AND DEPARTMENT LIKE 'varDEPT'

Runtime value is :

$HTTP_POST_VARS["txtLastName"] and
$HTTP_POST_VARS["mnuDept"]


-----------------------
Cirstoiu Aurel Sorin
InterAKT Support
www.interakt.ro
-----------------------