<?php

//SELECT * FROM `ttimestamps` WHERE timestamp_video_id=723 AND timestamp_parent_id=5670 AND timestamp_title LIKE 'gk%' ORDER BY timestamp_id ASC
//personal development - setting goals - finance


function selectStampsForVideoParent($video_id, $parent_id){
		$query = "SELECT * FROM ttimestamps WHERE timestamp_video_id='$video_id' AND timestamp_parent_id='$parent_id' AND timestamp_title LIKE 'gk%' ORDER BY timestamp_seconds ASC";
		$hand = new SelectAllQuery();
		$comments = $hand->query_select_all($query);
		return $comments;
}

$video_id = 723; //Dubs BlueBirds
$parent_id = 5670; //Dubs
$ans = selectStampsForVideoParent($video_id, $parent_id);

//print "<pre>"; print_r($ans); print "</pre>";
$ans_str = "";
for($x=0; $x < count($ans); $x++){
       $now = $ans[$x];
       $time = $now["timestamp_secondstext"];
       $ans_str .= $time;
       $ans_str .= " ";
       $ans_str .= $now["timestamp_title"];
       $ans_str .="<br>";
    }
    
    //print $ans_str;


?>