I am currently developing a website managing my movies, these are registered in a database and display in a table in html and php. Each title in the table contains a custom link like this:echo "<td><a target='Main_Frame' href='movie.php?Aname=" . $row['titre'] ."'>". $row['titre'] . "</a>"
I would like the movie.php page to display the information of the selected movie. Thanks.
Update
Please make sure that in your table movie_id
is available..
echo "<td><a href='movie.php?id=" . $row['ids'] ."'>". $row['titre'] . "</a>";
movie.php
$id=$_GET["id"];
$qry="select * from movie where movie_id=".$id;
$result = mysql_query($qry);
while($row = mysql_fetch_array($result))
{
// here is your move information
print_r($row);
}
I hope you are saving a movie_id in your movie table, so just add the movie_id to the custom link.
Movie.php Here you can get the movie_id that was passed and retrieve the corresponding movie details from the database.
For this you need Id.
For example:
echo "<td><a target='Main_Frame' href='movie.php?Aname=" . $row['ids'] ."'>". $row['titre'] . "</a>"
Do the following code in movie.php page.
$id=$_GET["ids"];
$qry="select * from movie where movie_id=".$id;
$result = mysql_query($qry);
while($row = mysql_fetch_array($result))
{
// here is your move information
print_r($row);
}
I hope its helpful to you..