Index: src/db/csv_to_db.php
===================================================================
--- src/db/csv_to_db.php	(revision 8946)
+++ src/db/csv_to_db.php	(revision 8968)
@@ -2,15 +2,35 @@
 
 // edit with personal settings
-function connectdb()
-{
- mysql_connect("location", "username", "password")
-  or die("Error connecting to mysql: " . mysql_error());
- mysql_select_db('database')
-  or die("Error connecting to database: " . mysql_error());
-}
-connectdb();
+$location = '';
+$username = '';
+$password = '';
+$database = '';
+$table = '';
+$file = '.csv';
+
+
+// connect to database
+mysql_connect($location, $username, $password)
+	or die("Error connecting to mysql: " . mysql_error());
+mysql_select_db($database)
+	or die("Error connecting to database: " . mysql_error());
+
+	
+// create table
+mysql_query("
+	CREATE TABLE IF NOT EXISTS ".$table." (
+		latitude double(9,7) NOT NULL,
+		longitude double(9,7) NOT NULL,
+		ssid varchar(45) NOT NULL,
+		mac varchar(45) NOT NULL,
+		encryption tinyint(4) NOT NULL,
+		ID int(11) NOT NULL AUTO_INCREMENT,
+		PRIMARY KEY (ID)
+	)
+");
+
 
 // .csv file to open
-if (($handle = fopen("file.csv", "r")) !== FALSE) {
+if (($handle = fopen($file, "r")) !== FALSE) {
 	while (($data = fgetcsv($handle, 1000, "\t")) !== FALSE) {
 		$lat=str_replace("N ", "", $data[0]);
@@ -18,5 +38,5 @@
 		$enc = substr($data[8], -2, 1);
 		echo "\"".$lat.", ".$lon."\", \"".$data[2]."\", \"".$data[4]."\", \"".$enc."\"<br />\n";
-		$query=mysql_query("INSERT INTO test_1 (latitude, longitude, ssid, mac, encryption) VALUES ('$lat','$lon','$data[2]','$data[4]','$enc')");
+		$query=mysql_query("INSERT INTO ".$table." (latitude, longitude, ssid, mac, encryption) VALUES ('$lat','$lon','$data[2]','$data[4]','$enc')");
 		if (!$query) {
 			die('Invalid query: ' . mysql_error());