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 :lol:

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 :oops: Am I on the right track???

Posted: Thu Sep 05, 2002 2:18 am
by gite_ashish
Sticky: Before Post Read: Concerning Passing Variables in PHP 4.2+

:arrow: http://www.devnetwork.net/forums/viewtopic.php?t=511

and also...

:arrow: http://www.php.net/manual/en/language.v ... efined.php


regards,

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 :lol:

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