Innovation Watch

Server unreachable"); MYSQL_SELECT_DB($database) or die ( "

Database non existent

"); // Perform query on lat-long database $query = "SELECT countryLONG, ipREGION, ipCITY, ipLATITUDE, ipLONGITUDE FROM IPCITYLATLONG WHERE (ipFROM <= $IPnum) AND (ipTO >= $IPnum)"; $result = mysql_query($query) or die('Query failed: ' . mysql_error()); // Retrieve contents of query $row = mysql_fetch_row($result); // Close connection to lat-long database MYSQL_CLOSE(); // -------- IF NO MATCH CHECK SECOND IP-LAT-LONG DATABASE ----------------- // Check for zeroes if ( empty($row[3]) && empty($row[4])) { // Set parameters for lat-long SQL-server $server= "localhost"; /* Address of 1&1 database server */ $user= "dbo144306122"; /* Database username */ $password= "ndea43466872"; /* Database Password */ $database= "db144306122"; /* name of database */ // Connect to lat-long database MYSQL_CONNECT($server, $user, $password) or die ( "

Server unreachable

"); MYSQL_SELECT_DB($database) or die ( "

Database non existent

"); // Perform query on lat-long database $query = "SELECT countryLONG, ipREGION, ipCITY, ipLATITUDE, ipLONGITUDE FROM IPCITYLATLONG WHERE (ipFROM <= $IPnum) AND (ipTO >= $IPnum)"; $result = mysql_query($query) or die('Query failed: ' . mysql_error()); // Retrieve contents of query $row = mysql_fetch_row($result); // Close connection to lat-long database MYSQL_CLOSE(); } // Exit if still no match found if ( empty($row[3]) && empty($row[4])) exit; // -------- WRITE RECORD IN VISIT DATABASE -------------------------------- // Set parameters for map SQL-server $server= "localhost"; /* Address of 1&1 database server */ $user= "dbo144304509"; /* Database username */ $password= "ndea43466872"; /* Database Password */ $database= "db144304509"; /* name of database */ $table= "userlocations"; /* name of table */ // Connect to map database MYSQL_CONNECT($server, $user, $password) or die ( "

Server unreachable

"); MYSQL_SELECT_DB($database) or die ( "

Database non existent

"); // Insert record in map database $row[2]= addslashes($row[2]); $query= "INSERT IGNORE INTO $table (lat,lon,country,region,city) VALUES ('$row[3]','$row[4]','$row[0]','$row[1]','$row[2]')"; $result= mysql_query($query) or die('Insert failed: ' . mysql_error()); // Close connection to map database MYSQL_CLOSE(); ?>

The future...
where does it come from anyway?

Innovation Watch follows developments in science, technology, business, society, global politics and the environment, and speculates about where they may be taking us. News feeds, weblogs, books and articles explore what the future might look like.

Have a personal or professional interest in change?
We have a growing collection of resources.

'); CarpConf('acb','
'); CarpConf('aidesc','

'); CarpConf('descriptiontags','b|/b|i|/i'); CarpCacheShow('http://feeds.innovationwatch.com/innovationwatch/webwatch'); ?>

'); CarpConf('acb','
'); CarpConf('iorder','link,date,desc'); CarpConf('maxititle',150); CarpConf('maxidesc',200); CarpConf('descriptiontags','b|/b|i|/i'); CarpCacheShow('http://feeds.innovationwatch.com/innovationwatch/newbooks'); ?>

Signs of the Future

	all categories
	business
	environment
	future
	global politics
	science
	society
	technology

The Futurist's Bookshelf

new books

Fast Forward

multimedia

Visitors: A Google map of recent visitors to Innovation Watch, based on city location. The map takes a few minutes to load.

Notable Quotes: Writers, scientists, philosophers and others share their thoughts about the future... what it is, why it is important, whether it can be predicted, and how we're going to get there.

The Rearview Mirror: Links to vintage media depicting life and change from the mid-1800s. Historical photographs, sound recordings, early motion pictures, and other rare materials.