Add link to PHP Populated drop down menu

I have a dropdown menu working which populates it's info from a database using PHP.

The query code is...

<?php

$dbhandle = new mysqli('localhost', 'un', pw, 'db');
$result = $dbhandle->query("SELECT e.*, DATE_FORMAT(`eventdate`,'%Y') as y FROM `events` e WHERE (`title` IS NOT NULL) AND Trim(`title`)!='' ORDER BY `eventdate` DESC");

$curyear = null;
while ($row = $result->fetch_object())
{
      if( $curyear!=$row->y )
      {
            if ($curyear != null) echo '</div>';
            $curyear=$row->y;
            echo '<div class=header id=divHeader', $curyear, '>', $curyear, '</div>';
            echo '<div class=content id=divContent', $curyear, '>';
      }
        echo $row->title, '<br />';
}
echo '</div>';
$dbhandle->close();
?>


It's all working fine ...http://www.anjoman.co.uk/previous-eventsbin.php

All I need to do is add a link to the event title that appear when the date is clicked.

The URL they need to go to is the event details page...<a href="previous-events-archive.php?date=<?php echo $row_events['eventdate']; ?>

I can't figure out where and how to place this link and would be grateful for any suggestions..

BrighteyesDesignAsked:
Who is Participating?
 
PranjalShahCommented:
Do you need to get the eventdate from one more query? I think your current query is getting the eventdate

so change your title line to...


echo "<a href=previous-events-archive.php?date=".$row->eventdate.">".$row->title."</a>";
0
 
BrighteyesDesignAuthor Commented:
Yep, that's done it, thanks for your help
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.