<div>
So inserting would be done how? &nbsp;These dates are entered so they are not always NOW()
</div>


So inserting would be done how?  These dates are entered so they are not always NOW()

<div>
well..<br />
<br />
&lt;?<br />
$date = &quot;2001-05-15&quot;; // for may 15th<br />
<br />
$link = mysql_connect($SQLHost, $SQLUser, $SQLPassword) OR DIE (&quot;Unable To Connect To Database&quot;);<br />
&nbsp; &nbsp; &nbsp;mysql_select_db($SQLDataba<wbr />se, $link) OR DIE(&quot;Unable To Select To Database&quot;);<br />
&nbsp; &nbsp; &nbsp;$sql=&quot;INSERT INTO tbl_name VALUES('$event_name', '$event_desc', '$date')&quot;;<br />
&nbsp; &nbsp; &nbsp;$result = mysql_query($sql);<br />
mysql_close($link);<br />
<br />
?&gt;
</div>


well..

<?
$date = "2001-05-15"; // for may 15th

$link = mysql_connect($SQLHost, $SQLUser, $SQLPassword) OR DIE ("Unable To Connect To Database");
     mysql_select_db($SQLDatabase, $link) OR DIE("Unable To Select To Database");
     $sql="INSERT INTO tbl_name VALUES('$event_name', '$event_desc', '$date')";
     $result = mysql_query($sql);
mysql_close($link);

?>

<div>
you can get the date from a form.. with 3 select (1 for day, 1 for month, 1 for year)
</div>


you can get the date from a form.. with 3 select (1 for day, 1 for month, 1 for year)

<div>
<div class="content wysiwyg-content">
I am creating an event calendar and what it to display the current month of events but I would also like to be able to click on a month name (so July for eample) and have a page generated that displays all of Julys events.<br />
<br />
What is the best way to store the date (when entering event dates) in order to achieve this?<br />
<br />
Also to keep in mind, once June is over, all of Junes old events must be archived. &nbsp;Either into a mySQL table or into a text file.
</div>
</div>


I am creating an event calendar and what it to display the current month of events but I would also like to be able to click on a month name (so July for eample) and have a page generated that displays all of Julys events.

What is the best way to store the date (when entering event dates) in order to achieve this?

Also to keep in mind, once June is over, all of Junes old events must be archived.  Either into a mySQL table or into a text file.

Retrieving only month needed?

PHP is a widely-used server-side scripting language especially suited for web development, powering tens of millions of sites from Facebook to personal WordPress blogs. PHP is often paired with the MySQL relational database, but includes support for most other mainstream databases. By utilizing different Server APIs, PHP can work on many different web servers as a server-side scripting language.