display timestamp different

[wazo]

Hi guys
My timestamp displays as 20070629104645

I want it like this 29/06/2007

Many thanks in advance

              

$sql = ("select * from   jobs where category = '$category'"); 








              $result = mysql_query ($sql);

              while ($row = mysql_fetch_array($result))
              {


  $title13 = $row["startdate"];



echo "$title13";


} 

[php_daemon]

$sql = "select *, date_format(startdate,'%d/%m/%Y') startdate from  jobs where category = '$category'";