Displaying articles for certain month and year

[Sharif]

I'm trying to setup a page where users can choose the month and year of news articles, and then have all the articles displayed for that current month and year. And also, if no month/year is chosen, then display all the articles for the current month. I'm having some trouble and I don't know where I messed up as the code seems perfect to me. The code is below:

<?php
//Build Form
echo "<form action=\"$PHP_SELF\" method=\"post\" name=\"select_date\" id=\"select_date\">
<p align=\"center\" class=\"bodyTEXT\">Month: 
<select name=\"m\">
  <option value=\"January\">January</option>
  <option value=\"February\">February</option>
  <option value=\"March\">March</option>
  <option value=\"April\">April</option>
  <option value=\"May\">May</option>
  <option value=\"June\">June</option>
  <option value=\"July\">July</option>
  <option value=\"August\">August</option>
  <option value=\"September\">September</option>
  <option value=\"October\">October</option>
  <option value=\"November\">November</option>
  <option value=\"December\">December</option>
</select>
Year: 
<select name=\"y\">
<option value=\"2003\">2003</option>
</select>
&nbsp;
<input name=\"submit\" type=\"submit\" id=\"submit\" value=\"Go\">
                </p>
              </form>";
//Build Variables
$now_month = date(F);
$now_year = date(Y);
if (!isset($m)) {
$m = $now_month;
}
else {
$m = $_GET['m'];
}
if (!isset($y)) {
$y = $now_year;
}
else {
$y = $_GET['y'];
}
$d = "$y-$m";
//Display Articles
echo '<table width="600" border="0" align="center" cellpadding="0" cellspacing="0">
  <tr>
    <td>';
		$display_title = mysql_query("SELECT id,date_FORMAT(date,'%m/%d/%Y at %l:%i:%s %p') AS date, title, teaser, news FROM news WHERE date = '$d' ORDER BY date DESC")
          or die ("MySQL Error");
     		if (mysql_num_rows($display_title) > 0)
     		{ 
        			while ($row = mysql_fetch_array($display_title)) 
        			{ 
				$id = $row ['id'];
				$date = $row ['date'];
				$title = $row ['title'];
				$teaser = $row ['teaser'];
				$news = $row ['news'];
				echo "<p class=\"TITLE3\"><b><a href=\"news.php?id=$id\" class=\"bodynav\">$title</a></b><BR>Posted On $date<BR>$teaser</p>";
				}
			}
echo  '</td>
  </tr>
</table>';
?>

[barand]

I altered things slightly to work with numeric months. Also its not a good idea to use field names like 'date' which is a reserved word. (I'm assuming 'date' is field of type DATETIME as you use date_format on it)

echo "<form action=\"$PHP_SELF\" method=\"post\" name=\"select_date\" id=\"select_date\">
<p align=\"center\" class=\"bodyTEXT\">Month:
<select name=\"m\">
  <option value=\"1\">January</option>
  <option value=\"2\">February</option>
  <option value=\"3\">March</option>
  <option value=\"4\">April</option>
  <option value=\"5\">May</option>
  <option value=\"6\">June</option>
  <option value=\"7\">July</option>
  <option value=\"8\">August</option>
  <option value=\"9\">September</option>
  <option value=\"10\">October</option>
  <option value=\"11\">November</option>
  <option value=\"12\">December</option>
</select>
Year:
<select name=\"y\">
<option value=\"2003\">2003</option>
</select>
&nbsp;
<input name=\"submit\" type=\"submit\" id=\"submit\" value=\"Go\">
                </p>
              </form>";
//Build Variables
$now_month = date(n);
$now_year = date(Y);
if (!isset($m)) {
$m = $now_month;
}
else {
$m = $_GET['m'];
}
if (!isset($y)) {
$y = $now_year;
}
else {
$y = $_GET['y'];
}

//Display Articles
echo '<table width="600" border="0" align="center" cellpadding="0" cellspacing="0">
  <tr>
    <td>';
        $display_title = mysql_query("SELECT id, date_FORMAT(`date`,'%m/%d/%Y at %l:%i:%s %p') AS thedate, title, teaser, news FROM news
        WHERE YEAR(`date`) = $y and MONTH(`date`) = $m ORDER BY date DESC");

hth

[Sharif]

WELL, this is what worked: It displayed the form, and all the articles for the current month. After selecting another month to display, this is the error I got:

--

ErrorYou have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'and MONTH(date) = ORDER BY date DESC'

Also, I changed the variable $now_month value to date(m) instead of date(n).

[barand]

The should be a month number between '=' and 'ORDER BY' so $m has no value

Should be (note the quotes) :-

$now_month = date('n');
$now_year = date('Y');

hth

[Sharif]

What do you mean, I don't understand...

[Sharif]

Don't worry about it guys, I got it to work. Now last question, is there a way to, after the month and year have been selected, display the current month selected in the form field (the one used to choose the month)?

[DeltaRho2K]

echo date("F", mktime(0,0,0,$m,10,$y));

or

$monthname = date("F", mktime(0,0,0,$m,10,$y));
echo $monthname;

[Sharif]

Wait how is this gonna work? Where do I put this?

[barand]

Build your select dropdown like this. It will select the month that is returned in $_GET['m']

echo "<select name=\"m\">";
for ($i=1; $i<=12; $i++) {
     echo "<option value=\"$i\" " . ($i==$_GET['m']?"selected":"") .
     "> " . date('F',mktime(0,0,0,$i,1,2003)) . "</option>";

}
echo "</select>";

hth