Retrieving timestamp value from MySQL database returns current date

Question

When retrieving "timestamp" value from MySQL table, my php file always returns the current date, not the timestamp date in which the row was added to MySQL table.

I know for sure that timestamp works right when adding new rows in MySQL, I´ve checked phpMyAdmin and values are right. But when I ask to retrieve them using php, all the entries are returned as current date, showing the date in which I´m asking MySQL to return the data, not the original timestamp value.

My timestamp attributes in MySQL are the following ones:

name: fecha / type: TIMESTAMP / null: FALSE / default value: CURRENT_TIMESTAMP

I´m using the following code to retrieve the timestamp values (I had to create a few variables to translate the English timestamp to Spanish):

    $query = mysql_query ("SELECT * FROM news;");

    while ($row = mysql_fetch_array ($query)){
        
            $row_date = strtotime ($row["fecha"]);
            date ("F j, Y", $row_date);
            $dias = array("Domingo","Lunes","Martes","Miercoles","Jueves","Viernes","Sábado");
            $meses = array("Enero","Febrero","Marzo","Abril","Mayo","Junio","Julio","Agosto","Septiembre","Octubre","Noviembre","Diciembre");
                    
    echo $dias[date('w')]." ".date('d')." de ".$meses[date('n')-1]. " del ".date('Y') ;
    }

It might be returning within correct form but you might be echoing it in wrong way — Narendrasingh Sisodia
– Narendrasingh Sisodia, Commented Apr 8, 2015 at 11:00

Suat Özgür · Accepted Answer · 2015-04-08 10:56:29Z

1

You need to pass $row_date to every date() call.

echo date('Y', $row_date) ;

answered Apr 8, 2015 at 10:56

Suat Özgür

411 bronze badge

Sign up to request clarification or add additional context in comments.

1 Comment

Pedro Peña Over a year ago

Wow, that was sharp. You´re right, I did only pass date() call to F j Y. I´ve got to try adding w d n into the "date" function and see if that works.

Collectives™ on Stack Overflow

Retrieving timestamp value from MySQL database returns current date

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related