i need help in query writing

[eluser]rcoder[/eluser]
Here is my query

SELECT idb_packages.i_sell_listing FROM idb_packages , idb_user WHERE idb_packages.i_package_id = idb_user.i_user_package AND idb_user.i_user_id = '1'

is it true ??

$this->db->select('idb_packages.i_sell_listing');
$this->db->from('idb_packages');
$this->db->from('idb_user');
$this->db->where('idb_user.i_user_id',$userid);
$this->db->where('idb_packages.i_package_id','idb_user.i_user_package');
$query = $this->db->get();

please help me..

[eluser]Armchair Samurai[/eluser]
I'm not sure how AR handles multiple from() calls, but it would work if you used a join().

Code:

$this->db->select('idb_packages.i_sell_listing');
$this->db->from('idb_packages');
$this->db->join('idb_user', 'idb_packages.i_package_id = idb_user.i_user_package');
$this->db->where('idb_user.i_user_id', $userid);
$query = $this->db->get();

[eluser]rcoder[/eluser]
thanks,your code is working fine