How could i store dates in sql as i upload pictures??

[2939195631902]

I'm trying to build a family website where family members could upload pictures. I know there are websites that allow us to do this, but i really want to build a personalized version myself.

Right now, i'm down to one problem. I'm trying to store the upload date into mysql and then sort the pictures by date when it appears on the website.

I have a pretty solid understanding of php and mysql, and i have thought of a way to accomplish this. However, my idea is really complex, unnecessary, and stupid.

This is much harder than i anticipated. Afterall, i can't exactly store dates in their format in mysql.

So if you got any good ways to accomplish this, i'll be pleased to hear them.

[Costin Trifan]

Assuming the table is named uploads and has a column named upload_date and the data type of this column is set to datetime having the default value set to "0000-00-00 00:00:00" ([y-m-d h:m:s] without quotes):

The insert query would look like:

PHP Code:

// INSERT
$query_insert = mysql_query("INSERT INTO uploads(upload_date) VALUES(CURRENT_TIMESTAMP())"); 


And the select query:

PHP Code:

// SELECT
$query_select = mysql_query("SELECT upload_date FROM uploads ORDER BY upload_date DESC");

// when displaying the date:
while ($info = mysql_fetch_assoc($query_select))
{
    echo '<p>Image uploaded on: '.gmdate("Y m d", strtotime($info['upload_date'])).' @ '.gmdate("H:i:s", strtotime($info['upload_date'])).'"</p>';
} 


^^ here you have to format how your date is displayed, I just used "Y m d" to get you started. more info(http://www.php.net/date)


give this a try and let us know how it went.

[2939195631902]

Thx man

That's is exactly what i was looking for.