[Resolved] My Gallery

NZ_Kiwi

Hi,

I've mad a gallery for my photos, all the information in stored in my SQL database and results are sorted by date...

How should i store the date format in my database

1/ If i added it as a string 02 Jun is would show before 28 May for example
2/ I would be added these weeks after they are taken and not in order of them being taken so a date() would not work

Any ideas?

devinemke

Originally posted by NZ_Kiwi
1/ If i added it as a string 02 Jun is would show before 28 May for example

never store dates in a database just a normal strings. use the DATE or DATETIME field type (YYYY-MM-DD or YYYY-MM-DD HH:MM:SS)

Originally posted by NZ_Kiwi
2/ I would be added these weeks after they are taken and not in order of them being taken so a date() would not work

sure [man]date[/man] can work. [man]date[/man] can be used to format any date, not just today's date. read the manual.

NZ_Kiwi

I've read high and low for weeks and i'm non the wiser...

On the user panel when a user adds the date should i add text box for them to add this data?

Then do i have to switch it to another format??

i've got no idea...

Frederick

I like to use the time() function for my stuff

// Insert into your sql
$curtime = time();

// Call your time and format as follows:
echo date("F j, Y",$row["postdate"]);

NZ_Kiwi

Originally posted by Frederick
I like to use the time() function for my stuff
// Insert into your sql
$curtime = time();

// Call your time and format as follows:
echo date("F j, Y",$row["postdate"]);
[/B]

But remember it's not the current time i'm adding

Frederick

I think I see what you are saying, when you setup your table field, set the number to:

month int(2) NOT NULL UNSIGNED ZEROFILL
day int(2) NOT NULL UNSIGNED ZEROFILL
year int(2) NOT NULL UNSIGNED ZEROFILL

You can use this type for sorting and for display.

$sql = mysql_query("SELECT * FROM tablename ORDER BY year DESC,month DESC,day DESC") or die (mysql_error());

This will list newest to oldest.

Weedpacket

You can (and should) still use the date time fields for date/time data. There is nothing stopping you from putting any date you (or the user) wants into such a field. If you don't want the current date, what date do you want?

NZ_Kiwi

Originally posted by Weedpacket
You can (and should) still use the date time fields for date/time data. There is nothing stopping you from putting any date you (or the user) wants into such a field. If you don't want the current date, what date do you want?

The date the picture was taken.

Weedpacket

Originally posted by NZ_Kiwi
The date the picture was taken.

Which presumably the photographer supplies when the photo is uploaded. Take that supplied date (in whatever form it's in), convert it into a string of the appropriate format (I suspect "yyyy-mm-dd" would be suitable) - PHP has plenty of string-handling functions that could do that (it also has date-handling functions, but you might not even need them in this case) and put that in the appropriate place in the INSERT query.