Need to scan MySQL table
| From: | Nik Gare | Date: | Sat, 04 Nov 2000 13:19:51 +0000 |
| Subject: | Need to scan MySQL table | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-23711@lists.php.net to get a copy of this message | ||
Hi,
I'm not too sure if this shoul be sent here or the MySQL mail list, so
just let me know...
I have data in a MySQL table in the following form:
type date details
report 2000-04-09 some details here
report 2001-06-16 some other details here
report 2000-04-16 some different details here
[lots more data with different dates]
What I would like to do is to make a menu out of just the dates, ie end
up with:
April 2000
June 2001
...
as links in the HTML.
I can probably suss out how to change the dates from 2000-04-09 to April
2000, but can not work out how to scan the dates field and just end up
with one occurence of each date.
I hope this makes sense,
Nik