ขอคำแนะนำด้วยครับ ต้องการ select ข้อมูลแบบเดียวกันหลายๆครั้งแต่เปลี่ยนเงื่อนไข

while ($data_f = mysqli_fetch_array($data_res)) {
        if (preg_match("/สว/",$data_f[position])) {
                $data_array['sor_wor'][$data_f[Id]] = $data_f;
        } else if (preg_match("/ผบช/",$data_f[position]) {
                $data_array['por_bor_chor'][$data_f[Id]] = $data_f;
        }
}

$strSQL=" SELECT DISTINCT ob.id,
ps.day 

FROM ob
LEFT JOIN position ON ob.idposition = position.idposition
LEFT JOIN ps ON ob.id = ps.id 
where position.positionlevel_name = 'ผบก.' AND positionname like '%$a[$i]%'  <---ใส่เงื่อนไขตามที่บอกแล้วครับ
group by ob.id 
order by  id_rank DESC,firstnow ASC,beforerank ASC,ranknow ASC,daybefore ASC,daypolice ASC,birth ASC; 
 ";

$objQuery = mysql_query($strSQL) or die ("Error Query [".$strSQL."]");



     
while($objResult = mysql_fetch_array($objQuery))
{


<td bgcolor="#FFFFFF"><?
				  
				   
		  DateThai($strDate2 );
$strDate2 = ($objResult["day"]);     <----- ในส่วนนี้ผมต้องใส่ข้อมูลยังไงครับ
if($strDate2 == "0000-00-00")
{
echo $strDate2 = "";
}
else
{
echo   DateThai($strDate2 );
}	    ?>&nbsp;</td>

<td bgcolor="#FFFFFF"><?
				  
				   
		  DateThai($strDate2 );
$strDate2 = ($objResult["day"]);    <----- ในส่วนนี้ผมต้องใส่ข้อมูลยังไงครับ
if($strDate2 == "0000-00-00")
{
echo $strDate2 = "";
}
else
{
echo   DateThai($strDate2 );
}	    ?>&nbsp;</td>


?>

<?
mysql_close($objConnect);

?>

<?
include "connect.php";
mysql_query("set character_set_results=tis620");
mysql_query("set character_set_connection=tis620");
mysql_query("set character_set_client=tis620");
$sql = "CREATE TABLE pss ("
        . " `id` INT(4) NOT NULL , "
        . " `name` VARCHAR(50) NOT NULL, "
		. " `position` VARCHAR(10) NOT NULL, "
        . " `day` DATE NOT NULL, "
        . " `positionname` VARCHAR(20) NOT NULL, "
        . " )"
        . " ENGINE = MYISAM;";  
$result=mysql_db_query("$dbname",$sql);
$a[1]="รอง สว.";
$a[2]="สว.";
$a[3]="ผกก.";
for($i=1;$i<=3;$i++){
$sql="select * from ps where positionname like '$a[$i]' ";
$result=mysql_db_query("$dbname",$sql);
while ($r=mysql_fetch_array($result)) {
	$id=$r[id];
	$day=$r[day];
	$positionname=$r[positionname];
    $sql2="select name from ob where id like '$id' ";
    $result2=mysql_db_query("$dbname",$sql2);
    while ($r2=mysql_fetch_array($result2)) {
	$name=$r2[name];
    }
	$sql3="select position from position where id like '$id' ";
    $result3=mysql_db_query("$dbname",$sql3);
    while ($r3=mysql_fetch_array($result3)) {
	$position=$r3[position];
    }
	$sq4="insert into pss values('$id','$name','$position','$day','$positionname')";
    mysql_db_query($dbname,$sq4);
  }
}
$sql="select * from pss order by id asc ";
$result=mysql_db_query("$dbname",$sql);
 echo "<TABLE  width='50%' BORDER=1 bgcolor=#FFFFCC>
  <TR align='center' bgcolor='#E9E9E9'> 
     <TD><B>id</B></TD>
	<TD><B>name</B></TD>
	<TD><B>position</B></TD>
    <TD><B>day</B></TD>
    <TD><B>positionname</B></TD>
  </TR>";
while ($r=mysql_fetch_array($result)) 
{
	$id=$i;
	$name=$r[name];
	$position=$r[position];
	$day=$r[day];
	$positionname=$r[positionname];
	echo "<TR> 
            <TD><div align='center'>$id</div></TD>
			<TD>$name</TD>
			<TD>$position</TD>
			<TD>$day</TD>
			<TD>$positionname</TD>";
 }
echo "</TABLE>";
?>