Need Help With Exploding CSV Data Within DB

[eluser]TheFuzzy0ne[/eluser]
Well, I don't see why you can't do it in two queries. The first query can get the column with the CSV numbers, and the second would get all rows with the specified IDs.

Code:

// Get the IDs from the table.
$this->db->where('zip_code', $zip_code);
$result = $this->db->get('my_table');

if ($result->num_rows() != 1)
{
    // Entry doesn't exist, or there are more than one row for that entry.
}
else
{
    // Explode the ids into an array.
    $ids = explode(",", $result->row()->ids);

    // Iterate through the exploded IDs, and use supply them to $this->db->or_where()
    foreach ($ids as $id)
    {
        $this->db->or_where('id', $id);
    }
    
    $result = $this->db->get('my_other_table');

    // Do something with the resulting rows.    
}

The above code is untested and designed to work with imaginary tables.

Hopefully it should help illustrate what you might need to do.