<div>
<br />

<pre><code class="code-1 nolinks" id="code-20-36905130-1"><span>SELECT blog_date FROM blog  group by blog_date  ORDER BY blog_date DESC LIMIT 12</span>
<span></span>
<span> echo  date(&quot;F Y&quot;, strtotime($row_Recordset_getallevents['blog_date']));</span>
</code></pre>
</div>


<div>
Hello Amigura, thanks for the help, that isnt the solution though, I want distinct months.. with your script, If I have 10 entries in september, it will display september 10 times...
</div>


<div>
my sql is perfect (i think) it is the display which is messing it up... if I display as <br />
<br />
&nbsp;$row_Recordset_getallevent<wbr />s['BlogMon<wbr />th'];<br />
<br />
if displays the proper unique months, it is once i am wrapping it in &nbsp;date(&quot;F Y&quot;, strtotime($row_Recordset_g<wbr />etallevent<wbr />s['blog_da<wbr />te'])); which is causing the probelm
</div>


<div>
hello, Roads roads... &nbsp;if I display &nbsp;as<br />
<br />
echo $row_Recordset_getallevent<wbr />s['BlogMon<wbr />th']; <br />
<br />
i get &nbsp;(which is correct)<br />
9<br />
8<br />
<br />
<br />
<br />
if I display as<br />
<br />
echo date(&quot;F&quot;, strtotime($row_Recordset_g<wbr />etallevent<wbr />s['BlogMon<wbr />th'])); <br />
<br />
I get <br />
october<br />
october<br />

</div>


<div>
what happens when you get rid of the LIMIT 12 ?
</div>


<div>
Hello,<br />
<br />
no difference...<br />
<br />
the problem is in my conversion to a pretty date....<br />
<br />
if I dump my &nbsp;DISTINCT MONTH (blog_date) &nbsp;AS BlogMonth,.... &nbsp; i have august(8) and september(9) entries...<br />
<br />
as soon as i try to make the display as august / september instead don 8 / 9 is where i get the problem
</div>


<div>
... as soon as i try to make the display as august / september instead OF 8 / 9 is where i get the problem
</div>


<div>
What about your database ? How do you store them inside ?
</div>


<div>
they are a date field...<br />
<br />
Roads, I do not think you are understanding my problem...<br />
<br />
I am able to successfully extract distinct months from my database as numbers....<br />
<br />
i do not want to display them as numbers, I want them to display as pretty text.. eg, january, february, etc...
</div>


<div>
Yes, I do understand, what you need is to convert the fields into names. You should provide some more data, a piece of the table for example. It is hard to diagnose the problem without knowing the db structure for example.
</div>


<div>
Hello,<br />
<br />
the field is a date field... &quot;date&quot; and the data is stored as &quot;2011-01-05&quot;<br />
<br />

</div>


<div>
Please make a query that says this: SELECT blog_date FROM blog ORDER BY blog_date DESC LIMIT 40<br />
<br />
Run that query, then use var_dump() to print every row of the output. &nbsp;Copy the output and post it into a code snippet here.
</div>


<div>
I don't get the &quot;only month&quot; extraction from the db but try this:<br />
<br />
echo &nbsp;date(&quot;F Y&quot;, mktime(0,0,0,$row_Recordse<wbr />t_getallev<wbr />ents['Blog<wbr />Month'],1,<wbr />2011));
</div>


<div>
SELECT MONTH(blog_date) as g, blog_date FROM blog GROUP BY g ORDER BY blog_date DESC LIMIT 12<br />
while ($v = $st-&gt;fetch_assoc()) {<br />
&nbsp;echo &nbsp;date(&quot;F Y&quot;, strtotime($v{'created'})),<wbr />&quot;&lt;BR&gt;&quot;;<br />
}<br />
<br />
outputs something similar to:<br />
<br />
September 2007<br />
August 2007<br />
July 2007<br />
June 2007<br />
May 2007<br />
April 2007<br />
March 2007<br />
February 2007<br />
January 2007<br />
December 2006<br />
November 2006<br />
October 2006
</div>


<div>
Hello Ray,<br />
<br />
i didn't use var_dump, but i did echo my loop and this is what I got..<br />
<br />
<br />
<br />

<pre><code class="code-1 nolinks" id="code-8224234"><span>2011-09-30</span>
<span>2011-09-22</span>
<span>2010-12-23</span>
</code></pre>
</div>


<div>
correction since the rest of the code is not relevant<br />
<br />
<br />
SELECT MONTH(blog_date) as g, blog_date FROM blog GROUP BY g ORDER BY blog_date DESC LIMIT 12<br />
echo &nbsp;date(&quot;F Y&quot;, strtotime($results_associa<wbr />tive_array<wbr />{'blog_dat<wbr />e'})),&quot;&lt;BR<wbr />&gt;&quot;;
</div>


<div>
Hello Roads,<br />
<br />
It is a blog.. i have a list of archives which are sorted by month, very similar to how wordpress does it...<br />
<br />
so I want to go into the database and get evert distinct month and then display them under my archive list of months... this could span over multiple years, so your code above will not work.... &nbsp;what i ahve so far and it works is this....<br />
<br />
SELECT DISTINCT MONTH(blog_date) AS BlogMonth, YEAR(blog_date) AS BlogYear &nbsp;FROM blog &nbsp;ORDER BY blog_date DESC LIMIT 12<br />
<br />
this is getting my correct months and years as numbers.. but i want to display the months as words, not intengers
</div>


<div>
i presume because of your code the the filed was just month<br />
<br />
if you want a specific year you might want to add a<b> where query</b> instead of limit 12<br />
<br />
will work on yyyy-mm-dd<br />
<br />

<pre><code class="code-1 nolinks" id="code-20-36905740-1"><span>SELECT blog_date FROM blog  group by DATE_FORMAT(`blog_date`,'%Y%m')  ORDER BY blog_date DESC LIMIT 12</span>
</code></pre>
</div>


<div>
ropener, i got a fatal error.. <br />
<br />
veryone here is my final code and the output.... tis works, it is just ugly...<br />
<br />
<br />
// output<br />
<br />
9 2011<br />
12 2010<br />
<br />
<br />
<br />
<br />

<pre><code class="code-10 nolinks" id="code-8224236"><span>$query_Recordset_getallevents = &quot;SELECT DISTINCT MONTH(blog_date) AS BlogMonth, YEAR(blog_date) AS BlogYear  FROM blog  ORDER BY blog_date DESC LIMIT 12&quot;;</span>
<span>$Recordset_getallevents = mysql_query($query_Recordset_getallevents, $newsstuff) or die(mysql_error());</span>
<span>$row_Recordset_getallevents = mysql_fetch_assoc($Recordset_getallevents);</span>
<span>$totalRows_Recordset_getallevents = mysql_num_rows($Recordset_getallevents);</span>
<span></span>
<span> &lt;?php </span>
<span> do { ?&gt;</span>
<span>   &lt;a href=&quot;blog_feed.php?month=&lt;?php echo $row_Recordset_getallevents['BlogMonth']; ?&gt;&amp;year=&lt;?php echo $row_Recordset_getallevents['BlogYear']; ?&gt;&quot;&gt;&lt;?php </span>
<span>   </span>
<span>  echo $row_Recordset_getallevents['BlogMonth'].&quot; &quot;. $row_Recordset_getallevents['BlogYear']. &quot;&quot;;</span>
<span>	 ?&gt;&lt;/a&gt;&lt;br /&gt;</span>
<span>   &lt;?php } while ($row_Recordset_getallevents = mysql_fetch_assoc($Recordset_getallevents)); ?&gt;</span>
</code></pre>
</div>


<div>
So there are only three lines?
</div>


<div>
thats it Roads.. mktime was what we were looking for...<br />
<br />
thank you everyone for your help
</div>


<div>
See <a href="http://www.laprbass.com/RAY_temp_jblayney.php" rel="ugc">http://www.laprbass.com/RAY_temp_jblayney.php</a><br />
<br />
I think my strategy would be to select the entire date into one variable and use that with strtotime() and date() to reformat the date into a named month.<br />
<br />
And I am not sure exactly what you want to do for output, but you might select MONTH() of the date column into another variable and use that in GROUP BY<br />

<pre><code class="code-10 nolinks" id="code-8224239"><span>&lt;?php // RAY_temp_jblayney.php</span>
<span>error_reporting(E_ALL);</span>
<span></span>
<span>date_default_timezone_set('America/New_York');</span>
<span></span>
<span>$arr = array</span>
<span>( '2011-09-30'</span>
<span>, '2011-09-22'</span>
<span>, '2010-12-23'</span>
<span>)</span>
<span>;</span>
<span></span>
<span>foreach ($arr as $date)</span>
<span>{</span>
<span>    echo &quot;&lt;br/&gt;&quot;;</span>
<span>    echo $date;</span>
<span>    echo &quot; &quot;;</span>
<span>    echo date('F', strtotime($date));</span>
<span>    echo PHP_EOL;</span>
<span>}</span>
</code></pre>
</div>


<div>
@jblayney: You might enjoy learning about how PHP and MySQL DATETIME strings work together. &nbsp;This article can help.<br />
<a href="https://www.experts-exchange.com/Web_Development/Web_Languages-Standards/PHP/A_201-Handling-date-and-time-in-PHP-and-MySQL.html" rel="ugc">https://www.experts-exchange.com/Web_Development/Web_Languages-Standards/PHP/A_201-Handling-date-and-time-in-PHP-and-MySQL.html</a><br />
<br />
Good luck with your project, ~Ray
</div>


<div>
Nice article Ray, thank you.
</div>


<div>
<div class="content wysiwyg-content">
Hello, simple little mistake.. i am trying to get and display all distinct months.. it is displaying them all as october 2011<br />
<br />
SELECT DISTINCT MONTH (blog_date) &nbsp;AS BlogMonth FROM blog &nbsp;ORDER BY blog_date DESC LIMIT 12<br />
<br />
&nbsp;echo &nbsp;date(&quot;F Y&quot;, strtotime($row_Recordset_g<wbr />etallevent<wbr />s['BlogMon<wbr />th'])); 
</div>
</div>


Hello, simple little mistake.. i am trying to get and display all distinct months.. it is displaying them all as october 2011

SELECT DISTINCT MONTH (blog_date)  AS BlogMonth FROM blog  ORDER BY blog_date DESC LIMIT 12

 echo  date("F Y", strtotime($row_Recordset_getallevents['BlogMonth'])); 

select distinct month

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.

MySQL is an open source, relational database management system that runs as a server providing multi-user access to a number of databases. Acquired by Oracle in 2009, it is frequently used in combination with PHP installations, powering most of the WordPress installations.