I am using a php script that uses mysql to store the data, when users register the dates do not show correctly, they just show as number for example "1225440861", how and where can I translate this to just the month and year?

http://www.php.net/date

I don't clearly see where to implement this code?

from a little bit down the page.

$today = date("F j, Y, g:i a"); // March 10, 2001, 5:16 pm
$today = date("m.d.y"); // 03.10.01
$today = date("j, n, Y"); // 10, 3, 2001
$today = date("Ymd"); // 20010310
$today = date('h-i-s, j-m-y, it is w Day z '); // 05-16-17, 10-03-01, 1631 1618 6 Fripm01
$today = date('\i\t \i\s \t\h\e jS \d\a\y.'); // It is the 10th day.
$today = date("D M j G:i:s T Y"); // Sat Mar 10 15:16:08 MST 2001
$today = date('H:m:s \m \i\s\ \m\o\n\t\h'); // 17:03:17 m is month
$today = date("H:i:s"); // 17:16:17

I take it this goes in the functions.php file so dates site wide are shown correctly?

Or in the database?

You use the formatting wherever you need to display a date on the page.

That field is of type timestamp, not date. Check you db. you need to convert it to date format from timestamp while showing.

$date = date("d/m-Y H:i:s"); / 01/11-2008 02:20:42

This should cover the most

`joindate` varchar(150) NOT NULL,
`lastlogdate` varchar(150) NOT NULL,

thats all i can find in referrence to date in the database.

Originally Posted by chrishirst

from a little bit down the page.

ok if i just use this method and on any page I need a date on, where would it go? before? after? does it need some extra code?

<?= $registroe["joindate"] ?> is the output for the date code in one instance.

Originally Posted by MuneyMan

`joindate` varchar(150) NOT NULL,
`lastlogdate` varchar(150) NOT NULL,

thats all i can find in referrence to date in the database.

Why varchar? Change them first to timestamp and then to datetime (I'm afraid that you can lose your data if changed from varchar to datetime directly).

i don't think you need to change the field type now. You can store the the timestamp in varchar field also, and i think you current script is doing that. For testing,

your timestamp in the first post:

$time_stmp = 1225440861;
echo date('Y-m-d',$time_stmp);

I wonder why did all these guys who spend years to develop freeware database engine decided to include separate data types for numbers, strings and dates if they could simply store EVERYTHING as varchar?

where would I implement that?

thanks for all the help guys btw

the timing code on the register page is set as this line of code and nothing else

$joindate=time();

that handles the code, I know joindate is the field in the users profile in the db as well as on the site. the =time(); is where the time is being handled, this is what needs to be changed I take it?

Nothing to wonder Mike, The database is already designed, and i don't think it will be possible for this guy to change the data type without losing data. That's my understanding. I am not here to prove how much i know, and how less the others.

MuneyMan please spend some time with PHP before you can start working.

Regards.

I have spent plenty of time with php just most on forum related mods and programming, I got everything else going with the software just stuck on the whole date thing.

Never seen this in a script

The date works fine everywhere else in the script just for some reason, the date added to a users profile when registering is what shows up as a line of numbers.

I have even tried swapping $joindate=time(); to $joindate=date();

That gives me this error upon registering: Warning: date() expects at least 1 parameter, 0 given

$joindate=date('Y-m-d,h:i:s'); you want the output something like that.

I got it working this morning!
Was simple don't know how I was missing it.

Thanks for the replies!