If - ElseIf - SQL Select... ASP YES.. PHP NO ???

[James]

Hi,
I have a form with 2 fields.
'A'
'B'

The user completes one of the fields and the form is submitted.

On the results page I want to run a query, but this will change
subject to which field is completed.

In ASP I can use:

queryA = request.querystring("A")
queryB = request.querystring("B")

If QueryA <>"" then
SQL STATEMENT

Elseif QueryB <> then
ANOTHER SQL STATEMENT

End If
The pages checks for a value in QueryA or QueryB then creates the
correct SQL Statement..

How do I do this in PHP ??

Thanks

[DB]

In news:3e****************@news.btclick.com,
James @ nothere.com (James) <James @ nothere.com (James)> typed:

Hi,
I have a form with 2 fields.
'A'
'B'

The user completes one of the fields and the form is submitted.

On the results page I want to run a query, but this will change
subject to which field is completed.

In ASP I can use:

queryA = request.querystring("A")
queryB = request.querystring("B")

If QueryA <>"" then
SQL STATEMENT

Elseif QueryB <> then
ANOTHER SQL STATEMENT

End If
The pages checks for a value in QueryA or QueryB then creates the
correct SQL Statement..

How do I do this in PHP ??

Thanks

If ($a) {
SQL STATEMENT
} elseif ($b) {
ANOTHER SQL STATEMENT
}

D.

[Rob Allen]

In message <3e****************@news.btclick.com>, James
<Ja***@nothere.com> writes

Hi,
I have a form with 2 fields.
'A'
'B'

The user completes one of the fields and the form is submitted.

On the results page I want to run a query, but this will change
subject to which field is completed.

In ASP I can use:

queryA = request.querystring("A")
queryB = request.querystring("B")

If QueryA <>"" then
SQL STATEMENT

Elseif QueryB <> then
ANOTHER SQL STATEMENT

End If
The pages checks for a value in QueryA or QueryB then creates the
correct SQL Statement..

How do I do this in PHP ??

Thanks

If(isset($_GET['A']) && $_GET['A'] != "")
{
// do something as a result of A being set
}
else if(isset($_GET['B']) && $_GET['B'] != "" )
{
// do somethign as a result of B being set
}
else
{
// neither set to something other than ""
}

--
Rob Allen

[The Script Smiths - PHP/PERL Developers]

"Nikolai Chuvakhin" <[e-mail]> wrote in message
news:32**************************@posting.google.c om...

James @ nothere.com (James) wrote in message
news:<3e****************@news.btclick.com>...

How do I do this in PHP ??
if ($_REQUEST['A']) {
SQL STATEMENT
} else {
if ($_REQUEST['B']) {
ANOTHER SQL STATEMENT
}
}

Since you are not specifying the method your form uses, I suggested
the use of $_REQUEST array. If you know whether you want to use
GET or POST, you can use $_GET or $_POST array as well.

Agreed, I fully recommend using $_REQUEST, etc over global variables.
One catch though, this requires PHP 4.1.0 or higher, there are hosting
services out there that still run 4.0.x, I know this cos I have clients with
this problem. Then this won't work

Prior to 4.1.0 there was no equivalent of $_REQUEST, so I guess you could
use globals if you must, otherwise use one of $HTTP_POST_VARS for forms,
$HTTP_GET_VARS for normal url gets.

Note, you can also write the above more compactly as:

if ( $_REQUEST['A'] ) {
SQL STATEMENT
}elseif ( $_REQUEST['B'] ) {
ANOTHER SQL
}


Cheers,
NC

Thanks,
Mark
----------------------------------------------------------------------------
--
Windows, Linux and Internet Development Consultant
Email: co*******@scriptsmiths.com
Web: http://www.scriptsmiths.com
----------------------------------------------------------------------------
--