สอบถาม php code search ค้นหา กับ format date ของ mysql

<form method="search">
<input type="text"  name="search2" class="search" value="" />
<div align="right">
<input type="submit" name="search2" id="search" value="search" class="small button orange-btn" onclick="submit()">
</div></form>

<section class="eight columns right-art">

<span class="columns">Search by Year:</span>
<span class="columns"><form method="post">
<select class="select-year1" name="year" onchange="submit();">
              <option>Please Select</option>
              <?
			  	$rs_year = mysql_query("select DISTINCT year from event where event_th_th!=\"NULL\" order by year ASC");
				while($rw_year = mysql_fetch_array($rs_year))
				{
					if($_POST['year']==$rw_year['year'])
					{
					?>
                    <option value="<?=$rw_year['year']?>" selected="selected"><?=$rw_year['year']?></option>
                    <?
					}
					else
					{
			  ?>
              <option value="<?=$rw_year['year']?>"><?=$rw_year['year']?></option>
              <? } } ?>
</select></form><!------End form select year ---------------------------------------------------------->
</span>

<span class="columns">Search by Month:</span>
<span class="columns"><form method="post">
<select class="select-year1" name="month" onchange="submit();">
              <option>Please Select</option>
              <?
			  	$rs_month = mysql_query("select DISTINCT month from event where event_th_th!=\"NULL\" order by month DESC");
				while($rw_month = mysql_fetch_array($rs_month))
				{
					if($_POST1['month']==$rw_month['month'])
					{
					?>
                    <option value="<?=$rw_month['month']?>" selected="selected"><?=$rw_month['month']?></option>
                    <?
					}
					else
					{
			  ?>
              <option value="<?=$rw_month['month']?>"><?=$rw_month['month']?></option>
              <? } } ?>
</select></form><!------End form select month ---------------------------------------------------------->
</span>
<div class="clr"></div>
<?
//////////////////// from search input text ///////////////////////////////////////////////////////

///////////////////from month select //////////////////////////////////////////////////////////////

///////////////////from year select //////////////////////////////////////////////////////////////
if($_POST['year']!='')
{
	$sql_event = 'select * from event where year="'.$_POST['year'].'" and event_th_th!=\'NULL\' and status=1 order by year DESC';
}
elseif(SEGMENT5!='')
{
	$sql_event = 'select * from event where year="'.SEGMENT5.'" and event_th_th!=\'NULL\' and status=1 order by year DESC';
}
else
{
	$sql_event = 'select *  from event where event_th_th!=\'NULL\' and status=1 order by year DESC';
}

	$result = mysql_query($sql_event);
	$total = mysql_num_rows($result);// นับจำนวนทั้งหมดในฐานข้อมูลตามเงื่อนไข sql ข้างบน
	##############################
	// กำหนดค่า config ให้กับ pagination class
	if(SEGMENT5!='')
	{
		if($_POST['year'])
		{
			$y = $_POST['year'];
		}
		else
		{
			$y = SEGMENT5;
		}
	}
	else
	{
		$y = $_POST['year'];
	}	
	if(SEGMENT7!="")
	{
		if($_POST['year'])
		{
			$p = 0;
		}
		else
		{
			$p = SEGMENT7;
		}
	}
	else
	{
		$p=0;
	}
	$page = $p  ;
	$config['base_url'] = BASE_URL.INDEX_PAGE.SEGMENT2."/".SEGMENT3."/".SEGMENT4."/".$y."/";
	$config['total_rows'] = $total;// ค่าที่นับได้"ทั้งหมด"จาก sql ด้านบน
	$config['per_page'] = 4;
	$config['num_segment'] = $page;
	$config['next_link'] = 'Next';
	$config['prev_link'] = 'Previous';	
	$pagination = new pagination($config);
	$start_item = (!isset($page) ? "0" : intval($page));
	##############################
	$sql_event .= " LIMIT ".$start_item.", ".$config['per_page'];	
	
	$rs_event = mysql_query($sql_event);
?> 
<?
$i=0;
while($rw_event = mysql_fetch_array($rs_event))
{ $i++;
?> 
<div class="twelve event">
<p><span class="columns text-left yellow">Exhibition Name &nbsp;&nbsp;</span>
<span class="columns  nine text-left  pad-none"><?=$rw_event['event_th_th']?></span></p>
<div class="clr"></div>
<p><span class="columns text-left yellow">Date of The Show</span>
<span class="columns  nine text-left  pad-none"><?=$rw_event["sdate_th_th"]?> - <?=$rw_event['edate_th_th']?></span></p>
<div class="clr"></div>
<p><span class="text-left yellow columns">Venue </span>
<span class="columns  nine text-left  pad-none"><?=$rw_event['venue_th_th']?></span></p>
<div class="clr"></div>
<p><span class="text-left yellow columns">Url Link</span>
<span class="columns  nine text-left  pad-none"><?=$rw_event['url_th_th']?></span></p>
<div class="clr"></div>
</div><? if($i%3==0){ echo "<div style=\"clear:both\"></div>"; } } ?> 
<div class="clr"></div>
<div class="row pag">
<div class="pag-number"><?php echo $pagination->create_links(); ?></div>
<div class="clr"></div></div>

</section><!----------End section class="eight columns right-art" ---------------------------------------------------------->

</section><!----------End section class="twelve grey-inset" ---------------------------------------------------------->
</section><!----------section class="row twelve" ---------------------------------------------------------->