Clickable row result

ss18

Hi all, i need some newbie help that shouldn't be to hard. Here's what i'm trying to.

I have a php page that returns the results on a predefined query in a table and that part works fine. I want to be able to click on the result, and have it pull up a new page with that field, and then the description field that in the same table on that row.

so basically you would see a Name, you click the name, and the attached desciption would come up.

I can't figure it out. I came up with this, but it obviously didn't work

print ("<td align=center valign=top><a href="$Row[Movie_Name]">$Row[Movie_Name]</a></td>\n");

Any help would be great, thanks

Brian

alanzhao

Do you want a separate page displays the movie info?

// movie.php, displaying the movies
$result = mysql_query("SELECT id, name FROM movie");
while($row = mysql_fetch_array($result) {
  echo "  <td><a href="movieinfo.php?movie=${row['id']}">${row['name']}</a></td>\n";
}


// movieinfo.php?movie=1 for example
// $_POST['movie'] = 1

$result = mysql_query("SELECT info FROM movie WHERE id='{$_POST['movie']}'");
$row = mysql_fetch_array($result);
echo $row['info'];

hope it helps.

ss18

Hey thanks for the help, but now i think i confused myself even more 🙂 there's a shocker!

Here is my page that use to display the table, bow nothing happens. Here is my code from top to bottom. Any help would be great.

Thanks

Brian

 

<?php
$Host = "localhost";
$User = "user";
$Password = "xxx";
$DBName = "stuff";
$TableName = "My_DVDs";

$Link = mysql_connect ($Host, $User, $Password);

$Query = "SELECT * FROM $TableName order by Movie_Name";

print ("<table border=1 width=\"75%\" cellspacing=2 cellpadding=2 align=center>\n");
print ("<tr align=center valign=top>\n");
print ("<td align=center valign=top><b>Movie Name</b></td>\n");
print ("</tr>\n");


// movie.php, displaying the movies
$result = mysql_query("SELECT id, Movie_Name FROM $TableName");
while($row = mysql_fetch_array($result) {
  echo "  <td><a href="movieinfo.php?movie=${row['id']}">${row['Movie_Name']}</a></td></tr>\n";
}

// movieinfo.php?movie=1 for example
// $_POST['movie'] = 1
$result = mysql_query("SELECT info FROM movie WHERE id='{$_POST['Movie_Name']}'");
$row = mysql_fetch_array($result);
echo $row['info'];


mysql_close ($Link);
print ("</table>\n");

?>

ss18

Hi! I never heard back from anyone on this, so i wasn't sure if i should move it to another catagory? or just post a follow up and see if someone might notice something.

THanks

Brian