It works!

1 files changed, 9 insertions, 4 deletions

diff --git a/www/youtube_functions.php b/www/youtube_functions.php
index 15153ec..17a8964 100644
--- a/www/youtube_functions.php
+++ b/www/youtube_functions.php
@@ -23,13 +23,18 @@ function searchterm(){
 
 	$table_array = array("english", "german");
 	$table_count = count("$table_array");
-	
-	$rows = $db->query("SELECT count(*) as count FROM german;");
+
+	$table=$table_array[0];
+
+	$rows = $db->query("SELECT count(*) as count FROM ". $table . ";");
 	$row = $rows->fetchArray();
 	$numRows = $row["count"];
 
-	
-	$search_word = mt_rand(1,$numRows);
+
+	$random = mt_rand(1,$numRows);
+	$search_word_db = $db->query("SELECT word FROM " . $table  . " WHERE id=" . $random . ";");
+	$search_word_ar = $search_word_db->fetchArray();
+	$search_word = $search_word_ar["word"];
 
 	return $search_word;
 }