Sorry the second elseif statement should have ended with : not ;
--
Jon Farmer
Systems Programmer, Entanet www.enta.net
Tel 01952 428969 Mob 07763 620378
PGP Key available, send email with subject: Send PGP Key
----- Original Message -----
From: "Jon Farmer" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Tuesday, December 18, 2001 1:12 PM
Subject: Re: [PHP-DB] Database query
> Ok you need to use PHP to decide what they have selected and construct a
sql
> statement based on that.
>
> for instance
>
> if ($location != "" && $discipline != "") :
> //construct variable with sql statement
> elseif ($location == "" && $discipline != ""):
> //construct variable with sql statement
> elseif ($location !="" && $discipline == "");
> //construct variable with sql statement
> else :
> // nothing selected
> endif;
>
>
> hth
>
> Jon
> --
> Jon Farmer
> Systems Programmer, Entanet www.enta.net
> Tel 01952 428969 Mob 07763 620378
> PGP Key available, send email with subject: Send PGP Key
>
> ----- Original Message -----
> From: <[EMAIL PROTECTED]>
> To: <[EMAIL PROTECTED]>
> Sent: Tuesday, December 18, 2001 12:49 PM
> Subject: [PHP-DB] Database query
>
>
> > Hi group,
> >
> > I am still getting to grips with PHP and MySQL and have a question that
> hopefully someone can easily answer:
> >
> > I have a search page which consists of two drop down menus, the user has
3
> ways of finding information.
> >
> > The first is by selecting a location and a discipline which would look
in
> the database and return any entries with the data in the two seperate
> fields.
> >
> > The second is where they can select the location only, and this will
> return all entries with that location
> >
> > The third is where they can select the discipline only, and again this
> will return all entries with that discipline.
> >
> > The problem I have is when the user selects the location and a
discipline
> which should return no results as it is not an exact match it is returning
> results as it contains part of the information.
> >
> > My sql query is as follows: $sql = "SELECT * FROM vacancy WHERE
> ('$related_discipline' = related_discipline and '$location' = location) or
> ('$related_discipline' = related_discipline) or ('$location' = location)
> ORDER BY ID LIMIT $limitvalue1, $limit";
> >
> > Could someone tell me what I need to change?
> >
> > Again help is always appreciated.
> >
> >
> > --
> > PHP Database Mailing List (http://www.php.net/)
> > To unsubscribe, e-mail: [EMAIL PROTECTED]
> > For additional commands, e-mail: [EMAIL PROTECTED]
> > To contact the list administrators, e-mail: [EMAIL PROTECTED]
> >
>
>
> --
> PHP Database Mailing List (http://www.php.net/)
> To unsubscribe, e-mail: [EMAIL PROTECTED]
> For additional commands, e-mail: [EMAIL PROTECTED]
> To contact the list administrators, e-mail: [EMAIL PROTECTED]
>
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
