Jocka Posted December 19, 2006 Share Posted December 19, 2006 Ok, straight to the point. I'm searching for "A" between one zip code and another zip code. But I have to go through B to do it.The problem is I say "SELECT bid FROM btable WHERE zip IN ('55555','55554,'55553,'55552,'55551')" and then I have the B information from the zip search. Now A gets it's information judging by bid. HOWEVER, I don't want to have it list out like this:b1-a1b1-a2b1-a3b2-a1b2-a2b3-a1b4-a1See what I'm saying? I don't want to draw out each A for the b. I want to draw out by the latest A regardless of the 'bid' ..I know some of you are confused. I just confused myself a little.The next best thing to do is save the 'bid' and 'zip' to A but I'd rather not. I can if I HAVE to but again, i'd rather not.There may be a way to do it with MYSQL alone but I'm not real good with MYSQL. Link to comment https://forums.phpfreaks.com/topic/31279-seeking-a-little-help/ Share on other sites More sharing options...
Psycho Posted December 19, 2006 Share Posted December 19, 2006 I think you need to restate your question. Is the list above is a representation of the results you woud get from your query? Are you trying to get the unique values of the 2nd part of those results. Link to comment https://forums.phpfreaks.com/topic/31279-seeking-a-little-help/#findComment-144753 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.