//for paging $func = new COMMONFUNC(); $db = new DB(); $fldAthleteid = isset($_REQUEST["fldAthleteid"]) ? $_REQUEST["fldAthleteid"] : 0; $fldYoutubelink = ""; $fldYoutubeModifiedDate = ""; $youID = ""; $error_msg = ""; if ($fldAthleteid > 0) { $query = " Select * from " . TBL_ATHELETE_REGISTER . " where fldId = '{$fldAthleteid}'"; $db->query($query); $db->next_record(); //$fldAthleteid = $db -> f('fldId'); $fldYoutubelink = $db->f('fldYoutubelink'); $fldYoutubeModifiedDate = $db->f('fldYoutubeModifiedDate'); $youID = $func->parse_yturl($fldYoutubelink); } if ($_POST['isSubmit'] == 'save') { $nowToday = date('Y-m-d H:i:s'); $where = "fldId = '{$fldAthleteid}'"; $New_youID = $func->parse_yturl($func->input_fun($_POST['fldYoutubelink'])); if (trim($New_youID) == trim($youID)) { $strDataArr = array('fldYoutubelink' => $func->input_fun($_POST['fldYoutubelink']), 'fldYoutubeModifiedDate' => $nowToday); } else { $strDataArr = array('fldYoutubelink' => $func->input_fun($_POST['fldYoutubelink']), 'fldYoutubeModifiedDate' => $fldYoutubeModifiedDate); } $db->updateRec(TBL_ATHELETE_REGISTER, $strDataArr, $where); $error_msg = '<div class="thankyoumessage" style="margin-right:29px;">YouTube Link updated successfully.<a href="#" onclick="javascript:self.close();" class="normalbtn" style="float:right; text-decoration:none;">Close</a></div>'; } /* if (count($error_msg)==0)