Add link to PHP Populated drop down menu

Posted on 2011-09-13
Medium Priority
Last Modified: 2012-05-12
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 />';
echo '</div>';

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..

Question by:BrighteyesDesign

Accepted Solution

PranjalShah earned 2000 total points
ID: 36531740
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>";

Author Comment

ID: 36531868
Yep, that's done it, thanks for your help

Featured Post

Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

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.

Join & Write a Comment

This article discusses four methods for overlaying images in a container on a web page
I recently worked on a Wordpress site that utilized the popular ContactForm7 (https://contactform7.com/) plug-in that only sends an email and does not save data. The client wanted the data saved to a custom CRM database. This is my solution.
The viewer will learn how to dynamically set the form action using jQuery.
The viewer will learn how to count occurrences of each item in an array.

607 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question