Noob question: Making search results clickable.

[Paul Jinks <pauljinks1@xxxxxxxxxxxxxx>]

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

-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php