FRIHOST FORUMS SEARCH FAQ TOS BLOGS COMPETITIONS
You are invited to Log in or Register a free Frihost Account!


Country / Province / Region / Town





andyd34
Does anyone know where I can get hold of a MySQL dump for Country / Province / Region / Town dump as I have just inadvertantly deleted mine, I would mind but it took 4 weeks 2 do it. Mad

It doesn't really matter whether its paid or unpaid I really need it ASAP my site cant function without it.
rvec
http://www.ilovejackdaniels.com/tools/internet-country-codes/
http://www.ilovejackdaniels.com/tools/uk-counties-select-box/
http://www.ilovejackdaniels.com/tools/us-states-select-box/

http://www.hkb.it/scripts/PHP//Hvilket%20land%20kommer%20brugeren%20fra.phps
If you want to make a php script you can just copy the array.


In the other comments you'll also find the codes in other formats.
andyd34
Thanks for your reply but I need something a bit more in depth, here is where I am currently up to and as you can see I have a long way to go.

Code:

mysql_query('CREATE TABLE destinations (
  id int(11) NOT NULL auto_increment,
  parent int(11) NOT NULL,
  `name` varchar(30) default NULL,
  children int(11) NOT NULL,
  PRIMARY KEY  (id)
)');
mysql_query("INSERT INTO destinations (parent, name, children) Values ('0','All','0')");
mysql_query("INSERT INTO destinations (parent, name, children) Values ('1','Africa','0')");
mysql_query("INSERT INTO destinations (parent, name, children) Values ('1','Asia','0')");

Delete due to space....

mysql_query("INSERT INTO destinations (parent, name, children) Values ('18','Louara','0')");
mysql_query("INSERT INTO destinations (parent, name, children) Values ('18','Mahourani','0')");
mysql_query("INSERT INTO de


As you can see I have a long way to go[/code]
Related topics
Reply to topic    Frihost Forum Index -> Scripting -> Php and MySQL

FRIHOST HOME | FAQ | TOS | ABOUT US | CONTACT US | SITE MAP
© 2005-2011 Frihost, forums powered by phpBB.