require_once('../../common/coonDB.php') ;
mysql_select_db($database_coonDB, $coonDB);
//$id = 15 ;
if( isset($id) )
$query_Recordset1 = sprintf("SELECT speech_id,table_title,speech_date,speech_order FROM speech_data WHERE speech_id= '%s'", $id );
else
$query_Recordset1 = sprintf("SELECT speech_id,table_title,speech_date,speech_order FROM speech_data WHERE table_title is not NULL ORDER BY speech_date DESC LIMIT 1");
//echo $query_Recordset1;
$Recordset1 = mysql_query($query_Recordset1, $coonDB) or die(mysql_error());
$row_Recordset1 = mysql_fetch_assoc($Recordset1);
$speech_id = $row_Recordset1['speech_id'] ;
$speech_date = $row_Recordset1['speech_date'] ;
$speech_order = $row_Recordset1['speech_order'] ;
$table_title = $row_Recordset1['table_title'] ;
if( !isset($id) )
$id = $speech_id ;
if( $speech_order > 0 )
$speech_date = $speech_date . '-' . $speech_order ;
mysql_free_result($Recordset1);
echo '
';
echo '
' . $table_title . '活動記錄';
?>