vibins — Tue, 31 May 2005 19:15:42 +0000

yes i am looking for the current year and thanks again for all your help

timjpriebe — Tue, 31 May 2005 19:04:55 +0000

Are you looking for the current year (ie 2005)? If so, that looks right to me.

Maybe you should post more of your code.

vibins — Tue, 31 May 2005 18:59:45 +0000

this is what the year variable should be right
$year= date("Y");

vibins — Tue, 31 May 2005 18:44:27 +0000

o sorry years is not defined sorry for the bother.

timjpriebe — Tue, 31 May 2005 18:42:48 +0000

Yep, that means $year is likely not defined. Try echoing $year right before you assign $result.

vibins — Tue, 31 May 2005 18:24:43 +0000

i got this
You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'ORDER BY id DESC' at line 1

timjpriebe — Tue, 31 May 2005 18:23:54 +0000

Also, is $year definitely set beforehand? If not, it could cause the problem.

timjpriebe — Tue, 31 May 2005 18:21:00 +0000

Try changing that first line to this one and see if it gives you a more detailed error message:

<?php
$result = mysql_query(\"SELECT timestamp, id, title FROM php_blog WHERE FROM_UNIXTIME( timestamp, '%Y' ) = $year ORDER BY id DESC\") or die(mysql_error());
?>

vibins — Tue, 31 May 2005 18:06:16 +0000

timjpriebe — Tue, 31 May 2005 12:37:48 +0000

If you test the query outside of the program, does it return any results?