TimeStamp

[JHallam]

Hey guys, just a quicky

Basically I have data coming from Mysql and I want to display the date in format ( 18-12-2003 / 22:30 )

timestamp is all set up, I'm getting the date this way, works but not nice to view

<?php print $row['TimeDate']; ?>

I've read upon this, but just cannot get my head around it...if someone could guide me, I would be so grateful

[LordShryku]

I'm guessing your field is in timestamp format? Look here

[dnszero]

$unixtimestamp = strtotime($timestamp)

$YourAnswer = date("d-m-Y / H:i", $unixtimestamp);

echo $YourAnswer;

[JHallam]

hmmm..Thanks for the rapid responses, I forgot to add something

I hav a table, which is displaying results from mysql

NAME -------------- DATE/TIME-------------EMAIL

basically like that, so I need to get the timestamp for each ID and then display it formatted!

Thanks so much guys

[JHallam]

hmm...well I have a loop for that, to display which ID, sorry

hmm...just need to get the timestamp from that $row

and format it...

[LordShryku]

Well, if you're field type is timestamp, dnszero's method probably won't work (refer to the thread I posted). Adding this to the loop is as easy as casting the type to unixtimestamp in the query and formatting using date() in the loop

[JHallam]

right, ok thanks

I got it displaying, but the problem is...the dates for each row are the same, when I have submitted them at different times

basically, the general concept is

emails submitted to Mysql

Content manager to delete, view, etc records

in the table showing all records, I want to add the date and time that record was submitted

so what I did, is place a timestamp and named the field "TimeDate"
Now Im using this to grab the data from it...

<?php $u_date = strtotime($row["TimeDate"]); $my_date = date("d/m/y G:i:s", $u_date);?><?php echo "$my_date" ?>

thats displaying - 01/01/70 0:59:59

arg!

[JHallam]

Can anyone help??

thankS!!!!

[LordShryku]

1) Don't be so impatient.
2) Stop using strtotime. If you're casting it to a timestamp in your SQL, there's no need to string it to time, now is there?

[JHallam]

1. When you have a deadline to meet, patience ins't a priority

2. If I knew that I would of not applied it

Thanks for your help may I add and Merry Christmas

[cahva]

Format the TimeDate field straight in mysql.. No need to use PHP for it.

$query="SELECT DATE_FORMAT(TimeDate,'%d-%m-%Y / %H:%i') as TimeDate,field2,field3(and so on..) FROM table";

People should really look at mysql's date and time functions...

[JHallam]

Thanks so much,

can you have a look at this for me...the way Im doing it is...

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 echo $row['TimeDate']; ?>

How would I intergrate the time format in with that? sorry if its a stooopid question!

Thanks again

[cahva]

Nah, not a stupid question 🙂 Just use that $query what I gave you in my last post. Replace field1,field2... to fields that are in your table. You cant use '*' to choose all if you format the date so you have to write all fields that you want to fetch from table.

[JHallam]

Ahh, I got it working with -

Ah I got wee help and I got this working

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

then I had a loop to display the records, so I used 

$row['display_date'];

and worked like a charm!

Thanks for all help!