DWMX, Msql, PHP syntax???

Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.

Moderator: General Moderators

Post Reply
digger69
Forum Newbie
Posts: 7
Joined: Sat Aug 24, 2002 7:32 am

DWMX, Msql, PHP syntax???

Post 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 :)
User avatar
Takuma
Forum Regular
Posts: 931
Joined: Sun Aug 04, 2002 10:24 am
Location: UK
Contact:

Post by Takuma »

The SQL query would work in PHP. Also what do you mean by runtime value?
digger69
Forum Newbie
Posts: 7
Joined: Sat Aug 24, 2002 7:32 am

Post 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???
User avatar
gite_ashish
Forum Contributor
Posts: 118
Joined: Sat Aug 31, 2002 11:38 am
Location: India

Post 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,
User avatar
Takuma
Forum Regular
Posts: 931
Joined: Sun Aug 04, 2002 10:24 am
Location: UK
Contact:

Post 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).
digger69
Forum Newbie
Posts: 7
Joined: Sat Aug 24, 2002 7:32 am

Post 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:
zeman
Forum Newbie
Posts: 1
Joined: Thu Sep 05, 2002 11:24 am
Contact:

Runtime variables

Post by zeman »

if (!isset($variable)) {
$varialble="xxx"
}

in PHP you can not easy define variables like in Cold Fusion..

Kenneth
http://www.zeman.cz
Post Reply