Help with merging arrays and selecting data from db

Discussion in 'PHP' started by egdcltd, Apr 23, 2009.

0
  1. #1
    What I am doing is SELECTING zonemap_types from multiple rows in a db table.
    Each row will return a zonemap_types result that is a comma seperated array of numbers. I want to merge these arrays into one larger array (no two numbers will be the same).

    Then, I want to run another SELECT operation on another table, but only selecting those results where the value zonemap_type is not in the merged array created from the first SELECT operation.

    I'm not sure how to go about this, can anyone help please?
     
    egdcltd, Apr 23, 2009 IP
  2. SmallPotatoes

    SmallPotatoes Peon

    Messages:
    1,321
    Likes Received:
    41
    Best Answers:
    0
    Trophy Points:
    0
    #2
    I think you may have a data normalisation problem.
     
    SmallPotatoes, Apr 23, 2009 IP