getGenComments.php

<?php
    error_reporting( 0 );
	//date_default_timezone_set("America/Chicago");
	require_once "dbConnectDtls.php";    
	
	$q = intval($_GET['q']); 	
	//$q = 2428;
	//echo("$q");
	
	// The if condition prevents the program from using the netID = 0 in the SQL
	if ($q > 0 ) {
	// This SQL gets the genComm from the TimeLog
        $sql = ("SELECT comment 
                  FROM `TimeLog` 
                 WHERE callsign = 'GENCOMM'
                   AND id = 0 
                   AND netID = $q
                 ORDER BY ID DESC
                 LIMIT 0,1
                ");

        foreach($db_found->query($sql) as $row) {
            $comment = $row[comment];
  		}  
  		
          // the htmlspecialchars(urldecode() stuff is so characters after the ampersand are still returned
          // see the example URL below 
  		  echo (htmlspecialchars(urldecode("$comment")));
  	}	
  		 
  		 // https://goto.webcasts.com/starthere.jsp?ei=1340938&tp_key=db6ffe8646
?>