Just want to display january from database

aa720

I managed to get my availability calender working. I put together the database and other bits and then found some code and did a bit of trial and error on it. The variables from database are called in to the following script. If the field has the word check inside it then the date is turned to bold,red with a strikethorugh. I would like to know how I can just display the month of january.
Your help would be appreciated.

//database stuff goes here ect, to big to list

<?
$time=mktime(12,0,0,1,1,date("Y"));
$endtime=mktime(10,0,0,1,1,date("Y")+1);

while ($time<$endtime) {
$name=strtolower(date("Mj", $time));
if ($$name==''){ ?>
<? echo"$name"; ?>
<? } elseif ($$name=='check') { ?>
<s><? echo"$name"; ?></s>
<? } ?>
</td>
<td> <?
$time+=24*3600;
}

<?
++$i;
}
?>

eriksmoen

SELECT * FROM databasename WHERE monthfield LIKE 'January'

...i think.

hope it helps.

cgraz

Or if your field contains more than just the month (meaning a date or timestamp field)

SELECT * FROM table_name WHERE DATE_FORMAT(field_name, '%M') = 'January'

Cgraz

aa720

I dont think I explained myself properly. In the code below how do I just display the month of january. The code is set to output upto dec31 but I only want it to do is show january.

<?
$time=mktime(12,0,0,1,1,date("Y"));
$endtime=mktime(10,0,0,1,1,date("Y")+1);