[eluser]tim1965[/eluser]
Sry if i am not clear (minus the beers i am in the same position as you, although i could murder one right now).
Ok from the top.
I am running two queries for a search page. The first generates some variable ids for the second query. On the second query i am trying to populate a where_not_in.
So my first query returns an array as above in my first post. I want to use this populate the where_not_in for my second query.
So the manual says do this
Quote:
$names = array('Frank', 'Todd', 'James');
$this->db->where_not_in('username', $names);
// Produces: WHERE username NOT IN ('Frank', 'Todd', 'James')
Quote:
However i cannot work out how to make my array thre same as the manual
Relevant part of my query is
$this->db->where_not_in('master_property_reference.property_id', $v);
//$this->db->where_not_in('username', $names);
$query = $this->db->get();
if($query->num_rows() >0)
{
$row=$query->result_array();
return $row;
}
with $v currently only being accessed by explicitly setting it to
$v=$r['0']['object_id'];
Obviously that wont work with more than one element.
My controller is
$result = $this->M_search_v1->check_dates();
So all i am trying to do is get the result of my first query to look like the manual says so thati can pass this->db->where_not_in an array to populate my second query.
I hope this is clear.