help with using IF and ELSE

[murdo]

ok i have a date output from a simple SQL database....

 

If "year" part of the date doesn't match, I want a standard message. if it does match, I want to echo the full date...

 

here is what I am using:

 

<?php
$year=date("Y");
if ($year=="2008")
  echo "N/A"; 
else
  echo "$date"; 
?>

 

All my dates in the database are 2008.. however on the page, I am getting the  $date  echo  instead of  "N/A"

 

am I doing something wrong??

[lemmin]

date() gets the current date, which is 2007. You don't have anything from your database query in this conditional statement.

[murdo]

ahhhhh i see where you are coming from! duh!!

 

So I use this:

 

$query="SELECT *, DATE_FORMAT(date,'%D %M %Y') as date2 FROM datestable

and

$date=mysql_result($result,$i,"date2");

 

so to show the date from the databse in my page, i do  <? echo $date; ?> but how do I condition that so if the year isn't 2008 it doesn't show??

[murdo]

never mind... problem solved...