I have a dropdown menu working which populates it's info from a database using PHP.
The query code is...
$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>';
echo '<div class=header id=divHeader', $curyear, '>', $curyear, '</div>';
echo '<div class=content id=divContent', $curyear, '>';
echo $row->title, '<br />';
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-arch
te=<?php echo $row_events['eventdate']; ?>
I can't figure out where and how to place this link and would be grateful for any suggestions..