of a
> last
> > name (even if all other fields are left blank) and return the records
> > meeting the
> criterion/criteria.
> >
> > Am I off my rocker?
> >
> >
> > - Original Message -
> > From: "Nick
> Stuart" <[EMAIL PROTE
* MikeParton
> I guess what might help is to explain that the form fields are on a page
> with method="POST" action=results.php
> The sql I provided originally is in results.php and I use the superglobal
> $_POST to pull the variables from the form field.
>
> I want the query results to be based
L PROTECTED]>
Sent: Tuesday, May 14, 2002 4:51 PM
Subject: Re: query for search on mysql database
> I think that was what roger is saying. If you simply change the OR's to
> AND's your searchwill
> work as you want it to. For example some one looks for a person by the
> la
in. Need some pointers on how to start that.
Thanks!
Mike
- Original Message -
From: "Roger Baklund" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Cc: "MikeParton" <[EMAIL PROTECTED]>
Sent: Tuesday, May 14, 2002 3:49 PM
Subject: RE: query for search on
* MikeParton
> I have a similar query in a PHP script. I want to allow users to
> use fields
> in a page to search for the records. BUT, I want them to be able to enter
> the first few characters. I would think my query, below, would do it (the
> entire search works when the WHERE statement has
<[EMAIL PROTECTED]>
Cc: "Aman Raheja" <[EMAIL PROTECTED]>
Sent: Tuesday, May 14, 2002 2:47 PM
Subject: RE: query for search on mysql database
> * Aman Raheja
> > I am making a search program. I am looking for a query.
> > I want to allow the
* Aman Raheja
> I am making a search program. I am looking for a query.
> I want to allow the user to search "Any" or "All".
> Anyhow, suppose the database contains the following
>
> Author
>
> | Rim Torus |
> | Jerry Pal Deprado |
> | Roan P. Classy |
> --
