simple problem to be fixed about records

mistercash60000

Hmm I'm very new to this php coding stuff.

I have a database wich I can call up with mysql en php.
I can view a page with all my movies their titles.
But now I want to make when I click on a title that another page detail.php called opens and shows the details of that movie like actors and other stuff. the detail.php their I already made a select clause based on the title. So it shows only one record.
The one I clicked.

But how can I make this?

I have been looking on this forum because I know that someone else already requested this thing but I don't find it.
Sorry mate to ask it again.

LordShryku

How can you make what? The page? Or the ability to click to get to the page?

mistercash60000

well when I click on a title. that it shows all the details of that title.
the abillity to click and show the details thats what I have to know.

LordShryku

Well, the ability to click would just be to create a link out of the title. Since you didn't show us any of your code, here's what I would do

while($row=mysql_fetch_array($result)) {
    echo "<a href=\"detail.php?title=".$row['title']."\" target=\"_blank\">".$row['title']."</a>";
}

Then on detail.php, select everything you need from the database and display it.

mistercash60000

this are my pages in code:

This the page with al the movietitles:

<?php require_once('Connections/mysqlthuis.php'); ?>
<?php
mysql_select_db($database_mysqlthuis, $mysqlthuis);
$query_Recordset1 = "SELECT * FROM peter ORDER BY ORIGINALTITLE ASC";
$Recordset1 = mysql_query($query_Recordset1, $mysqlthuis) or die(mysql_error());
$row_Recordset1 = mysql_fetch_assoc($Recordset1);
$totalRows_Recordset1 = mysql_num_rows($Recordset1);
?>
<html>
<head>
<title>Movies</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
</head>

<body bgcolor="#666666" text="#FFCC00" link="#FFCC00" vlink="#FFCC00" alink="#FF0000">

<table border="0" width="100%">
  <tr> 
    <td width="40%" height="23"><u><strong><font size="4">ORIGINALTITLE</font></strong></u></td>
    <td width="10%"><u><strong><font size="4">RATING</font></strong></u></td>
    <td width="40%"><u><strong><font size="4">VIDEOFORMAT</font></strong></u></td>
    <td width="10%"><u><strong><font size="4">DISKS</font></strong></u></td>
  </tr>
</table>
 <img src="Image/Line.gif" width="100%">
 <br>
 <table width="100%">
  <?php do { ?>
  <tr> 
    <td width="40%"><a href="detail.php"><?php echo $row_Recordset1['ORIGINALTITLE']; ?></a></td>
    <td width="10%"><img src="\Image\Rating<?php echo $row_Recordset1['RATING']; ?>.gif" alt="Rating of:<?php echo $row_Recordset1['RATING']; ?>"></td>
    <td width="40%"><?php echo $row_Recordset1['VIDEOFORMAT']; ?></td>
    <td width="10%"><img src="\Image\CDAmount<?php echo $row_Recordset1['DISKS']; ?>.gif" alt="Amount of disks is: <?php echo $row_Recordset1['DISKS']; ?>"></td>
  </tr>
  <?php } while ($row_Recordset1 = mysql_fetch_assoc($Recordset1)); ?>
</table>


</body>
</html>
<?php
mysql_free_result($Recordset1);
?>

And this is the code where all the details should be shown when I click a link:

<?php require_once('Connections/mysqlthuis.php'); ?>
<?php
$maxRows_Recordset1 = 1;
$pageNum_Recordset1 = 0;
if (isset($HTTP_GET_VARS['pageNum_Recordset1'])) {
  $pageNum_Recordset1 = $HTTP_GET_VARS['pageNum_Recordset1'];
}
$startRow_Recordset1 = $pageNum_Recordset1 * $maxRows_Recordset1;

$colname_Recordset1 = "1";
if (isset($HTTP_GET_VARS['ORIGINALTITLE'])) {
  $colname_Recordset1 = (get_magic_quotes_gpc()) ? $HTTP_GET_VARS['ORIGINALTITLE'] : addslashes($HTTP_GET_VARS['ORIGINALTITLE']);
}
mysql_select_db($database_mysqlthuis, $mysqlthuis);
$query_Recordset1 = sprintf("SELECT * FROM peter WHERE ORIGINALTITLE = '%s'", $colname_Recordset1);
$query_limit_Recordset1 = sprintf("%s LIMIT %d, %d", $query_Recordset1, $startRow_Recordset1, $maxRows_Recordset1);
$Recordset1 = mysql_query($query_limit_Recordset1, $mysqlthuis) or die(mysql_error());
$row_Recordset1 = mysql_fetch_assoc($Recordset1);

if (isset($HTTP_GET_VARS['totalRows_Recordset1'])) {
  $totalRows_Recordset1 = $HTTP_GET_VARS['totalRows_Recordset1'];
} else {
  $all_Recordset1 = mysql_query($query_Recordset1);
  $totalRows_Recordset1 = mysql_num_rows($all_Recordset1);
}
$totalPages_Recordset1 = ceil($totalRows_Recordset1/$maxRows_Recordset1)-1;
?>

<html>
<head>
<title>Details of Movies</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
</head>

<body bgcolor="#666666" text="#FFCC00">
<h1><font color="#FFCC00" face="Times New Roman, Times, serif"><strong><?php echo $row_Recordset1['ORIGINALTITLE']; ?></strong></font><br>
  <img src="Image/Line.gif" width="100%" height="6"></h1>
<table width="100%" border="0">
  <tr> 
    <td width="48%" rowspan="7"><img src="/cover/<?php echo $row_Recordset1['PICTURENAME']; ?>" alt="<?php echo $row_Recordset1['ORIGINALTITLE']; ?>" width="480" height="444" align="absmiddle"></td>
    <td height="73" colspan="3" valign="top"><font size="+3"><strong><u>Movie 
      Details</u></strong></font></td>
  </tr>
  <tr> 
    <td width="9%" height="65" valign="top"><font color="#FFFFFF">Director:</font></td>
    <td colspan="2" valign="top"><?php echo $row_Recordset1['DIRECTOR']; ?></td>
  </tr>
  <tr> 
    <td height="155" valign="top"><font color="#FFFFFF">Actors:</font></td>
    <td colspan="2" valign="top"><?php echo $row_Recordset1['ACTORS']; ?></td>
  </tr>
  <tr> 
    <td height="29" valign="top"><font color="#FFFFFF">Category:</font></td>
    <td colspan="2" valign="top"><?php echo $row_Recordset1['CATEGORY']; ?></td>
  </tr>
  <tr> 
    <td height="23" valign="top"><font color="#FFFFFF">Year:</font></td>
    <td colspan="2"><?php echo $row_Recordset1['YEAR']; ?></td>
  </tr>
  <tr> 
    <td valign="top"><font color="#FFFFFF">Country:</font></td>
    <td colspan="2"><?php echo $row_Recordset1['COUNTRY']; ?></td>
  </tr>
  <tr> 
    <td height="160" valign="top"><font color="#FFFFFF">Description:</font></td>
    <td colspan="2" valign="top"><?php echo $row_Recordset1['DESCRIPTION']; ?></td>
  </tr>
  </table>
  <br>

<table width="100%">
  <tr valign="top"> 
    <td height="67" colspan="6"><font size="+3"><strong><u>Technical Details</u></strong></font></td>
  </tr>
  <tr> 
    <td width="10%" height="21"><font color="#FFFFFF">Video format:</font></td>
    <td width="21%"><?php echo $row_Recordset1['VIDEOFORMAT']; ?></td>
    <td width="20%" align="right"><?php echo $row_Recordset1['VIDEOBITRATE']; ?></td>
    <td width="4%" align="left"><font color="#FFFFFF">kbps</font></td>
    <td width="23%" align="right"><font color="#FFFFFF">Resolution:</font></td>
    <td width="22%" align="right"><?php echo $row_Recordset1['RESOLUTION']; ?></td>
  </tr>
  <tr> 
    <td height="21"><font color="#FFFFFF">Audio format:</font></td>
    <td><?php echo $row_Recordset1['AUDIOFORMAT']; ?></td>
    <td><?php echo $row_Recordset1['AUDIOBITRATE']; ?></td>
    <td><font color="#FFFFFF">kbps</font></td>
    <td align="right"><font color="#FFFFFF">Framerate:</font></td>
    <td align="right"><?php echo $row_Recordset1['FRAMERATE']; ?></td>
  </tr>
  <tr> 
    <td height="21"><font color="#FFFFFF">Language:</font></td>
    <td><?php echo $row_Recordset1['LANGUAGES']; ?></td>
    <td>&nbsp;</td>
    <td><font color="#FFFFFF">&nbsp;</font></td>
    <td align="right"><font color="#FFFFFF">Filesizes</font></td>
    <td align="right"><?php echo $row_Recordset1['FILESIZE']; ?></td>
  </tr>
  <tr> 
    <td height="21"><font color="#FFFFFF">Subtitle</font></td>
    <td><?php echo $row_Recordset1['SUBTITLES']; ?></td>
    <td>&nbsp;</td>
    <td><font color="#FFFFFF">&nbsp;</font></td>
    <td align="right"><font color="#FFFFFF"># disks:</font></td>
    <td align="right"><?php echo $row_Recordset1['DISKS']; ?></td>
  </tr>
</table>
<p>&nbsp;</p>
</body>
</html>
<?php
mysql_free_result($Recordset1);
?>

I hope you now understand what I want to do.
Thanks for helping me mate