DWMX, Msql, PHP syntax???

[allanb]

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

SELECT EMPLOYEEID, LASTNAME, FIRSTNAME, DEPARTMENT, EXTENSION 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

😕

[jmcneese]

$sql = "SELECT EMPLOYEEID, LASTNAME, FIRSTNAME, DEPARTMENT, EXTENSION 
FROM EMPLOYEES 
WHERE LASTNAME LIKE '%". $lastname ."%' 
AND DEPARTMENT LIKE '%". $dept ."%'";