แนะนำการเรียก วดป จากฐานข้อมูลมาคำนวณอายุ พี่ครับ ผมขอตัวอย่าง การดึง วันเดือนปี จากฐานข้อมุลมาคำนวณ

$birth = select Date_birth from Table;

while($date = mysql_fetch_array($birth)){

$year =  explode ("/",$date['Date_birth']);

$age = $year[2]+543;

}

$search = mysql_query("select * from Table where ID = '$id' or Name = '$name'");

  <form action="test.php" method="post" id="form1">
             <table>
             <tr>
             <td>
             
             <input name="searchtb" type="text" id="searchtb" />
             </td>
             <td>
			 <select name="group" class="TextBox" id="group" style="width:151px;" >
                              <option value="">---Choose  search---</option>
                          
                              <option value='id'>id</option>
                               <option value='name'>name</option>
                             
                            </select> 
                            
                     </td>
                     <td>
                     <input type="submit" name="Submit" value="&nbsp;&nbsp;search&nbsp;&nbsp;" >
                     </td>
                     </tr>
             <tr>
             <td colspan="3">
             <?
			 $group = $_POST['group'];
			 $searchtb = $_POST['searchtb'];
             if(!empty($group)){
				 
				if($group == 'id'){
					$id = mysql_query("select * from school where ID_Sc = '$searchtb'");
					while($search = mysql_fetch_array($id)){
						echo $search[Name_Sc];
					}
				}else if($group == 'name'){
				
					$name = mysql_query("select * from school where Name_Sc = '$searchtb'");
					while($search = mysql_fetch_array($name)){
						echo $search[ID_Sc];
					}
				}
			 }
			 ?>
             </td>       
			 </tr></table>
             </form>