Stuart Felenstein wrote:
The returned values should be exact. As far as how
much data, I'm assuming your talking about amount of
records ?
Potentially eventually maybe quite a bit.
Currently mysql statement is comprised of select and
from with all the proper joins.
But I"m confused, when you say b
Right, I thought the rules were mentioned in the first
post. Apoplogies. The user should be able to enter
one value or all 6 and with each additional value
added from none, the results should be more refined.
i.e. Alabama chosen only - all jobs in Alabama come
back
Alabama and Financing - all fi
Stuart.
If your queries must match _all_ of your input variables, you are in the
situation where you only need ANDs (no ORs needed). Just create one term
in your WHERE statement for each field they filled in and make sure that
there is an AND between each of them in the right places. This sh
The returned values should be exact. As far as how
much data, I'm assuming your talking about amount of
records ?
Potentially eventually maybe quite a bit.
Currently mysql statement is comprised of select and
from with all the proper joins.
But I"m confused, when you say below actual SQL call
here,
Depending on how exact the returned values need to be, and how much data
you have to
sift through, you could do. ( perl example )
$job=$dbh->quote($job.'%');
$city=$dbh->quote($city.'%');
$start=$dbh->quote($start.'%");
.
.
.
$select = "SELECT * from myfile where jobtitle like $job and city like
Hi,
Hi Stuart,
Getting your brains warped by logical statements, eh?
If I remember correctly AND has precedence over OR. That means that the
statement "A or B and C " evaluates to "A or (B and C) " which means that
the statement will be true if A is true or if both B and C are true.
When in
My brain is warped by web development in general ;)
Thanks for your response. After I sent this , I got
an email from the PHP list, with a good chunk of code
to show how it's done. Yes, scripting is the only way
for this type of query.
Thank you for the response.
Stuart
--- [EMAIL PROTECTED] wr
Hi Stuart,
Getting your brains warped by logical statements, eh?
If I remember correctly AND has precedence over OR. That means that the
statement "A or B and C " evaluates to "A or (B and C) " which means that
the statement will be true if A is true or if both B and C are true.
Because of t
I'm back, trying to figure my way through a somewhat
confusing set of conditons.
Sort of doing a sanity check here.
First explanation:
I've put together a search (the database) form that
has 6 inputs.
Just to clarify, the fields are
1-JobTitle
2-City
3-Start
4-Industry
5-State
6-TaxTerm.
The idea
