How to do drop down monthly archive

Hi everyone ,

I am new to php.I need help on how to do the drop down monthly archives for my management report that will pull down the seller’s name and the amount as for that particular month (e.g October). The detail is as below.

The sql table for the management report date is
(id, sellername, sale amount, date)

[table]
[tr]
[td] Jmonthly archieve e.g October 2010 (in drop down list format)[/td]
[/tr]
[tr]
[td][seller name ][seller total amt][/td]
[/tr]
[tr][td]
[td[/td]
[/tr]
[/table]

Your help is appreciated. Thank you.
cheer
sunny

Sponsor our Newsletter | Privacy Policy | Terms of Service