--- a/develop/models/home.php	Mon Mar 02 16:16:54 2015 +0100
+++ b/develop/models/home.php	Tue Mar 03 10:33:42 2015 +0100
@@ -6,7 +6,32 @@
 	}
     
     public function Test() {
-        return array("Test Value 1", "Value 2", "Value 3");
+
+    	/* uncomment to do the merge
+    	// merge books table with books_info table
+    	$query = "SELECT books_info.volume, books_info.author, books_info.edition, books_info.books_id FROM books INNER JOIN books_info ON books.id=books_info.books_id";
+    	
+    	$result = mysql_query($query);
+        if (!$result) {
+            return json_encode("Failed during selecting books, books_info table.");
+        }
+        $query = "ALTER TABLE books_v1 ADD Column volume VARCHAR(50), ADD Column author VARCHAR(100), ADD Column edition VARCHAR(100);"
+        $result_alter = mysql_query($query);
+
+        while ($row = mysql_fetch_assoc($result)) {
+        	// insert row into books_v1 table
+        	echo $row['volume'].$row['author'].$row['edition'].$row['books_id'];
+            
+            $query_update = "UPDATE books_v1 SET `volume`='".$row['volume']."', `author`='".$row['author']."',`edition`='".$row['edition']."' WHERE `id`='".$row['books_id']."'";
+				      
+            $result_update= mysql_query($query_update);
+            if (!$result_update) {
+                echo json_encode("error");
+
+            }
+        }
+		*/
+        return;
     }
     
 }