How would I get the current year

[c-o-d-e]

How would I get the current year? I can get the current time, but Year, I think will be different. The year should be the full year eg: 2009. Not 09.

$year = //Get the current year

$query = mysql_error("UPDATE Users SET Used = '$year' WHERE username = '$username'") or trigger_error('Query failed: '. mysql_error());

[ShadowIce]

<?php echo date('l, F jS Y h:i:s A'); ?>

 

Your welcome!

[PFMaBiSmAd]

It's almost always best and faster to perform an operation using mysql funcitons directly in a query -

$query = mysql_error("UPDATE Users SET Used = YEAR(CURDATE()) WHERE username = '$username'") or trigger_error('Query failed: '. mysql_error());

[c-o-d-e]

Can you explain what all that does ShadowIce? I notice it has time, it should only have the Year.

So when updating the database, the value would become "2009" etc.

 

PFMaBiSmAd, would YEAR(CURDATE()) display the year, or the whole date?

 

Thanks for the replies.

[PFMaBiSmAd]

What the YEAR() and CURDATE() functions do can be found in the documentation - http://dev.mysql.com/doc/refman/5.0/en/date-and-time-functions.html

 

 

[ShadowIce]

It returns the time followed by the date.

 

I'll edit it so it returns only the date ^^

 

<?php echo date('l, F jS Y'); ?>

 

try that ^^

[c-o-d-e]

Ok thank you. How do I solve this topic, I cant find the solve button.

[ShadowIce]

Try renaming the title maybe ^^

[PFMaBiSmAd]

The 'topic solved' modification has yet to be installed in the upgraded forum software.