date ranges without time

[Lcousins]

Hi all,

I am slowly managing to get a release schedule dbase up and running, each item in the database has a date 'yyyy-mm-dd'.

I am currently trying to make a simple front end with search facitilities, one of which is allowing the user to select a month and then be shown all the releases in that month. Im fine on the showing of the releases part, but Im stuck on how to allow the user to select the month from a pull down box (specifically the next 12 months from whichever month is currently the present one) and then how to use that to search for all items with a relase date in that month.....

I have got as far as having a form variable 'dates' which value is in the form 'yyyy-mm-dd' which show the start of the month, but I cant get from here to also having an end date for the mysql query. All the date functions appear to involve time, yet all i am interested in is month.

any ideas??

luke

[njm]

You could the MySQL functions MONTH() and YEAR() etc. in your query.

hth, njm

[Grisu]

I guess the selected month is stored in the variable $month.

1) The select-field
<select name='month'>
<?php
for ($i = 1; $i < 13; $i++) {
echo "<option value='$i'";
if ($i == (int) (date("n"))) echo " selected='selected'";
echo ">$i</option>";
}
?>
</select>

2) why not try the SQL-function month?
SELECT * FROM whatever WHERE MONTH(datefield) = $month

Grisu

[marque]

I like to make select box's like this:

echo "<select>";
for($i=0;$i<12;$i++)
	{
	$stamp = mktime(0,0,0,date("m")+$i,1,date("Y"));
	echo "<option value=\"".date("m",$stamp)."\">";
	echo date("M",$stamp);
	echo "</option>\n";
	}
echo "</select>";

that will give you a select box with each month, with the current month being the first option. It won't be obvious because it's january, but if you change:

$stamp = mktime(0,0,0,date("m")+$i,1,date("Y"));
to:
$stamp = mktime(0,0,0,6+$i,1,date("Y"));

you will see it starts in june

[Lcousins]

thanks both, I had been concentraing on finding a way to create a new date in php based on the original one for use in a 'BETWEEN' mysql query, but I see now the way you have suggested is much easier!!!

regards

L.