On Friday 13 June 2003 15:48, G & E Holt wrote: > I hope this is something easy I am overlooking but here goes: > > I have a table called: country which has the following fields: > > Field Type > ip_from double(11,0) > ip_to double(11,0) > country_code char(2) > country_name varchar(50) Shouldn't you be using some INTEGER type instead of DOUBLE? An unsigned INT will just about handle it (2^32). -- Jason Wong -> Gremlins Associates -> www.gremlins.biz Open Source Software Systems Integrators * Web Design & Hosting * Internet & Intranet Applications Development * ------------------------------------------ Search the list archives before you post http://marc.theaimsgroup.com/?l=php-db ------------------------------------------ /* It seems like the less a statesman amounts to, the more he loves the flag. */ -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php