[RESOLVED] Display results from the results of query !??

djalecc

I think I got that title right, but my mind is going sideways over this one.

Here is my problem...

Currently I have a search that when someone types for example m32 in to the box, the results are all 'jobs' that are like the postcode 'm32' from the pick up location.

It also searches the delivery postcode field, so if there was a job either picking up from m32 or delivering to m32 the results would be displayed.

if ($display == "searchpostcode") {
$sql="select * from tablename WHERE q34 = 'Multiple Sources' AND q39 = 'Job Available' AND q17 LIKE '%$searchpcode%' OR q34 = 'Multiple Sources' AND q39 = 'Job Available' AND q19 LIKE '%$searchpcode%' ORDER BY `id` DESC ";
}

When you type MK in to the search box the results work well, it pulls the 2 jobs because one has a MK pick up post code and the other has a MK delivery post code.

This is ok and works well.... however now I also want to have a seperate search that goes like this...

Lets say I live in Manchester and type M32 in to the search box.
Bingo! I get 1 job, from M32 to MK42... I'm on my way...

But from the results before we know there is another job in MK to take to SN1, this did NOT come up in the result, and this is my dilemma.

Starting from the INPUT search,(m32) seach for jobs with that matching pickup postcode, (ok there is 1, pick up M32, deliver MK42) then seach for jobs that Match the Delivery Postcode of the result (MK), and if it finds a match display it, and continue searching to see if now there is a job picking up in postcode SN.

So if I typed m32 in to the box, it would find that job, and now find the job from MK1 to SN1, (because the first job returned MK42 as the delivery post code, it matched the MK and found a job that needs PICKING up from MK) it would then look for more jobs PICKING UP from SN1 ( because the 2nd result was picking up in MK1 and taking to SN1) and so on and display these to... if any...

Any ideas on how this might be done? 😕

q17 is the pick up postcode and q19 is the delivery post code.

bastien

try

$sql="select * from tablename WHERE q34 = 'Multiple Sources' AND q39 = 'Job Available' AND (q17 LIKE '%$searchpcode%' OR q19 LIKE '%$searchpcode%') ORDER BY `id` DESC ";
}

Jason_Batten

The query is disgusting. Use brackets.

q34, q39 etc. are the name of the fields? That's :quiet:

... Read MySQL Crash Course by Ben Forta

djalecc

bastien wrote:

try

$sql="select * from tablename WHERE q34 = 'Multiple Sources' AND q39 = 'Job Available' AND (q17 LIKE '%$searchpcode%' OR q19 LIKE '%$searchpcode%') ORDER BY `id` DESC ";
}

I don't think I explained my problem correctly...

Thanks for the response, but this will not work because $searchpostcode is the input from the FORM...

What I need is the above SQL AND another that searches for q19 from the FIRST SQL result of whatever is in q19.

So... here I try to explain more clearly in the hope someone can help me...

My First search I enter m32 in to the FORM and it gives me this result.

Job ID | Type | Pick Up | Deliver.

JOB : 1244 |2 -3 Day Service |M32 0RY | MK42 7QH

Now I type MK in to the FORM and it gives me this result..

Job ID | Type | Pick Up | Deliver.

JOB : 1253 |Same Day Service | mk1 | sn1
JOB : 1244 |2 -3 Day Service |M32 0RY | MK42 7QH

Notice job 1244 is also included in this result because it has MK in one of the poscodes.

What I want it to do via a DIFFRENT search INPUT FORM is this..

I type M32 in to the DIFFERENT search FORM and it gives me this result...

JOB : 1244 |2 -3 Day Service |M32 0RY | MK42 7QH
JOB : 1253 |Same Day Service | mk1 | sn1

It would produce this result BECAUSE, from the START my search was M32, it found a PICK UP in M32 and displays it, but I am delivering TO MK42, so it now searches the other available jobs to see if anything can be PICKED UP from the MK postcode, so it finds job 1253 is PICKING UP in MK and displays this job.

IF it also found a Pick Up in SN then it would ALSO display this job too!!

Because after I deliver to MK, I pick up in MK, then drive to SN.

So I start my day picking up in M32, delivering to MK43, then picking up in MK1 and delivering to SN1.

If there was a job picking up in SN, it would pull this job and display it aswell and so on until no more matches were found.

Hard to get your head around, and even harder for me to code 😕

Hope this explaines it more clearly 😃

djalecc

Ok, done it to a point, loop inside a loop, inside a loop, inside a loop.

works!... but probably cumbersum!