Unique Month Problem

[Anon]

I implemented the following code in my PHP script:

$months = mysql_query("SELECT DISTINCT DATE_FORMAT(storydate, '%M %Y') FROM news");

Now, I just need to know how to display the results that are returned. This database query will search through all of the dates, and it will only print out January 2001, March 2001, etc. if it finds a date that falls under that category. The query will print everything out fine in phpMyAdmin, but I don't know how to get it to work in a PHP script. Any help would be greatly appreciated.

[kaleina]

$months = mysql_query("SELECT DISTINCT DATE_FORMAT(storydate, '%M %Y') FROM news");

while ($row = mysql_fetch_array($months)) {
echo $row[0];
}

that should print it out. You should look into php.net's mysql functions, you still need to connect to the database before running this query. 🙂