Create links to show some mysql request

pedromau

Hello people!
I'm trying to do something for about 3 days and I really see no way out on this... can be something simple, but I really suck at php...

I have this php agenda that uses mysql DB... Then I have a search option that looks for event name, description of the event and date.

this is my query

$result = @("SELECT DATE_FORMAT(event_date, '%d - %m - %Y') as event_time, subject, event_id, local, DAYOFMONTH(event_date) as day, MONTH(event_date) as month, YEAR(event_date) as year FROM calendar_event WHERE DATE_FORMAT(event_date, '%Y') LIKE '%".$this->search."%' OR subject LIKE '%".$this->search."%' OR local LIKE '%".$this->search."%' OR detail LIKE '%".$this->search."%' AND queue_flag = 0 ORDER BY event_date DESC");

What I need to do is to create some links (or list menu) that shows all the events from a year (if I use the search form and look for "2006" all the events from 2006 show up, but I need to have direct links - menus - to list the events from that year).

Can someone PLEASE help before I get my grandfather's shotgun?!

Thank you!

Roger_Ramjet

More detail like php and mysql version numbers would help: major diferences in how to solve this depending on those versions, eg stored procs in mysql v5, PDO in php v5, etc.

General solution: create your form with a <select> list for the years then in the target script

if (isset($_POST['submit']) && isset($_POST['year'])) {
   $sql = "SELECT .....
// etc