$sql="select * from careers order by addeddate desc";
$result=mysql_query($sql);
$count=mysql_num_rows($result);
if(mysql_num_rows($result)>0)
{
$cou=1;
while($row=mysql_fetch_assoc($result))
{
$jobno=$row["jobno"];
$heading=$row["heading"];
$details=$row["details"];
$addeddate=$row["addeddate"];
$mon = date("m", strtotime($addeddate));
$date = date("d", strtotime($addeddate));
$yr = date("Y", strtotime($addeddate));
$date=$date."-".$mon."-".$yr;
?>
JOB No : echo $jobno ?>
Post : echo $heading ?>
Qualification : echo $details ?>
Added Date : echo $date ?>
$cou++;
}
}
?>