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:3ef953a4.167992089@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 <3ef953a4.167992089@news.btclick.com>, James
<James@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" <nc@iname.com> wrote in message
news:32d7a63c.0306250838.3f7583a9@posting.google.c om...

> James @ nothere.com (James) wrote in message
> news:<3ef953a4.167992089@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: [email]corporate@scriptsmiths.com[/email]
Web: [url]http://www.scriptsmiths.com[/url]
----------------------------------------------------------------------------
--