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

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

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.

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

"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: corporate@scriptsmiths.com
Web: http://www.scriptsmiths.com
----------------------------------------------------------------------------
--