<?php

include 'connection.php';
$sqlSettings = 'SELECT * FROM `tbl_sentence` WHERE suggestion_count = 5 AND is_open_for_voting = 0 ';
$resultSettings = $mysqli->query($sqlSettings);
if($resultSettings->num_rows > 0) {
	while ($row = $resultSettings->fetch_object()) {
		$sentence_id = $row->id;
		// insert winning sentence table record into clone tableINSERT INTO tbl_winning_sentence
		/*$sqlDuplicateSentence = 'INSERT INTO tbl_winning_sentence
		SELECT * FROM tbl_sentence
		WHERE id = "'.$sentence_id.'"';
		$resultDuplicateSentence = $mysqli->query($sqlDuplicateSentence);

		// insert winning sentence suggessions table records into clone tableINSERT INTO tbl_winning_sentence
		$sqlDuplicateSuggession = 'INSERT INTO tbl_user_winning_suggestion_mapping
		SELECT * FROM tbl_user_suggestion_mapping
		WHERE sentence_id = "'.$sentence_id.'"';
		$resultDuplicateSuggession = $mysqli->query($sqlDuplicateSuggession);*/
		
	}
} ?>