2 Replies Latest reply on Nov 20, 2006 10:19 PM by Newsgroup_User

    List into Query?

    Level 7
      This should be simple, but I can't wrap my head around it.

      A user inputs their zip code into a page. A list of nearby zip codes is
      returned from the database, separated by commas. No problem, that part's

      I want to take that list of zip codes and blend it with the next query that
      takes place.

      The current query takes two search criteria and returns results from the
      database. But I want to tell the query that each record returned from the
      database must contain one of the zip codes in the list that was just
      generated. I'm using MySQL if it matters.