weird myslql and timestamp thing....

[raffael3d]

I have a column in my datatbase which is the timestamp. through this I tried to get, when a submission had taken place. now I try to output this on my page unsing this script:

a
$result = @mysql_query("SELECT id,DATE_FORMAT(date,'%M, %D, %Y') as datum,,resume,location FROM jobs WHERE id=$detail");

while ( $row = mysql_fetch_array($result) ) {
$id = $row["id"];
$datum = $row["datum"];
print  ($row["datum"]);
}

now what is happening? Every day the date seems to change. it always changes the timestamp to the todays date. the seconds in the timestamp remain, also the minutes, but the day and month get updated....altough I don't do anything. what is wrong? what can I do???

[[deleted]]

it is here:
$result = @("SELECT id,DATE_FORMAT(date,'%M, %D, %Y') as datum,,resume,location FROM jobs WHERE id=$detail");
change it to
$result = @("SELECT id,DATE_FORMAT(date,'%d-%M-%y %H:%i') as datum,,resume,location FROM jobs WHERE id=$detail");

try it......