Taking unix timestamp from MySQL and printing in PHP

kaykills

Hi,
I have searched for answers to my question, and some answers have come close but I am still having trouble. I have managed to get as far as being able to store a unix timestamp in a MySQL field. What I cannot do is then take that number and put it back onto a php page. I want to call on that field and place it on my page in format you can understand. Can someone please help. I have done some ridiculous things but the closest i got was the following

print date("d/M/y G.i", 'unixtimestamp');

unixtimestap being my field... does the field have to be a certain type??? Thank you for helping. I am very tired.
Michael

mattotto77

when querying the table which holds the date add this to the sql

select * date_format(fieldname, '%d%M%y') as date1

echo "date1";

(Note you will have to change the way the date is displayed by modifying the %d%M%y.

hope this helps

kaykills

so i tried using the above code and........ don't think i'm an idiot but I can't get anything to print..... this is what I do:

$result = mysql_query( "SELECT * FROM sched1 ORDER BY unixtimestamp DESC date_format(unixtimestamp, '%d%M%y') as date1" );

echo "date1";

all i get is date 1..... when i load the page..... do I need to have the field setup a certain way in MySQL to hold a timestamp???

kaykills

all i need to do is take the unix timestamp from the field in the mySQL table and print it out in a format that everyone can read......

mattotto77

Try this

$query = "SELECT *, date_format(unixtimestamp, '%d%M%y') as date1 FROM sched1 ";

$result = mysql_query($query);
$row = mysql_fetch_assoc($result);

echo "$row[date1]";

keith73

I wouldn't use dateformat in the sql.

your php code where you call date() is the problem.

post all the php code that leads up to that print date() line because that would help.

you can't just do

print date("d/M/y G.i", 'unixtimestamp');

what you're doing is passing a string containing the word unixtimestamp.
your second parameter needs to be an INT, in this case an epoch timestamp.
what is the data type for the column you are retrieving?

this is what I usually do.
the timestamp column is usually an unsigned int
retrieve the data using mysql_query then loop through the results.
I usually use mysql_fetch_object, but for this I'll use mysql_fetch_assoc.

then when it comes time to print the date:

print date('d/M/y G.i',$row['timestamp_column_name']);

keith