SQL query to Active Record

SQL query to Active Record

El Forum
Guest

10-29-2009, 07:25 AM

[eluser]echoDreamz[/eluser]
Thanks @puzzlebox.

I came up with

$CI->db->select('code, name')->from('country_ips')->join('country_codes', 'country_ips.country_id = country_codes.country_id')->where("'{$ipaddr}' BETWEEN `start` AND `end`", NULL, FALSE)->limit(1);

So very similar to yours Smile

. Works too Smile

Messages In This Thread

SQL query to Active Record - by El Forum - 10-28-2009, 08:53 PM

SQL query to Active Record - by El Forum - 10-29-2009, 01:25 AM

SQL query to Active Record - by El Forum - 10-29-2009, 07:25 AM