Page 1 of 1
DWMX, Msql, PHP syntax???
Posted: Wed Sep 04, 2002 11:57 pm
by digger69
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

Posted: Thu Sep 05, 2002 1:03 am
by Takuma
The SQL query would work in PHP. Also what do you mean by runtime value?
Posted: Thu Sep 05, 2002 1:57 am
by digger69
Thanks for Answering,
What is a runtime value?
I was hoping you would know
To the best of my *limited* knowledge it is to do with defining variables.
As in for JSP it would be:
Name= varLastName
Default Value= %
Run-Time Value= request.getParameter("txtLastName")
For Coldfusion it would be:
Name= varLastname
Default Value= %
Run-Time Value= #("txtLastName")#
for PHP would it be????????????????
Name= varLastname
Default Value= %
Run-Time Value= $_REQUEST["txtLastName")
Hope this makes sense

Am I on the right track???
Posted: Thu Sep 05, 2002 2:18 am
by gite_ashish
Posted: Thu Sep 05, 2002 2:48 am
by Takuma
Do you mean getting the field? I don't know what is run time value, since i don't use ASP (though I know a little about it).
Posted: Thu Sep 05, 2002 3:13 am
by digger69
Thank you very much for your help Takuma,
While my question is to do with PHP, it is probably more suited to a Dreamweaver MX forum.....
The problem is thier not very active forums....
Thanks anyWay

Runtime variables
Posted: Thu Sep 05, 2002 11:24 am
by zeman
if (!isset($variable)) {
$varialble="xxx"
}
in PHP you can not easy define variables like in Cold Fusion..
Kenneth
http://www.zeman.cz