TimeStamp format

[someguyinaussie]

Hey guys,

thanks for taking a look firstly,

<?php
db connections etc 
$query = "SELECT * FROM mortgage"; 
$result = mysql_query($query); 
?>
HTML CODE for tables etc 
<?php 
while($row = mysql_fetch_assoc($result))  
{ 
?>
then for the results like - 
<?php "DATE_FORMAT(TimeDate,'%d-%m-%Y / %H:%i')"?><?php echo $row['TimeDate'];?> 

This displays the date "20031219114515" but doesnt format it to what I would like

could you tell me where Im going wrong, thanks

[bcolflesh]

Put the Date_Format in your SELECT statement, ie:

SELECT *, DATE_FORMAT(TimeDate,'%d-%m-%Y / %H:%i') AS display_date

[someguyinaussie]

Ok thanks for that but how do I put it in with the select already there?

$query = "SELECT * FROM mortgage";

Where do I put it?

thanks!

[bcolflesh]

$query = "SELECT *, DATE_FORMAT(TimeDate,'%d-%m-%Y / %H:%i') AS display_date FROM mortgage";

Remember to echo display_date to get the formatting.

[someguyinaussie]

Thanks so much, I know for the future now

Hmm...
having a slight problem displaying it

Im using

<?php echo $display_date?>

I've tried

echo "$display_date"

etc

but still is just blank!

[jatar_k]

based on this bit

while($row = mysql_fetch_assoc($result))

you would need to do

echo $row['display_date'];

[bcolflesh]

Thanks jatar_k - came back too late!

[someguyinaussie]

What can I say, thank you so much guys, been such a help...I value this immensely

thank you!