Noob question: Making search results clickable.
| From: | Paul Jinks | Date: | Wed, 18 Nov 2009 15:04:13 +0000 |
| Subject: | Noob question: Making search results clickable. | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-299907@lists.php.net to get a copy of this message | ||
Hi all
I'm building a fairly basic php/mySql site but I'm running into
problems due to my total lack of experience. I have a database of
videos - each has a title, transcript, description and one or more
topics. So far I can search the database by topic (using a drop-down
menu), like this:
<?php
$result = mysql_query("SELECT title FROM videos WHERE topic1= '$topic'");
while($row = mysql_fetch_array($result))
{
echo $row['title'];
echo "<br />";
}
?>
Basic, but it works. What I'd like now is to make the search results
clickable so clicking them leads to a page showing all the details of
that video. I have a page "video_display.php" set up, ready to display
the details from the database, but how do I connect the two?
Thanks in advance
Paul