displaying a sql query from another page

[Strife]

<?
@ $db = mysql_pconnect("localhost");

if (!$db)
{
echo "Error: Could not connect to database. Please try again later.";
exit;
}

mysql_select_db("mysql");
$manga_sql = "select * from manga
where title is not null
order by title desc";

$manga_result = mysql_query($manga_sql);
if (mysql_num_rows($manga_result)) {

$manga = mysql_fetch_array($manga_result);
echo "<a href=\"review.php?id=$manga[id]\">";
echo $manga[title];
echo "</a>";

}

?>

This is the mysql query that is run on index.php
If someone clicks on a link that sends them to review.php?id=1,
how do i get review.php to recognize the id that is called and display the information from that row.

[mikesgt2]

Use code like this in "review.php"

<?php

/* just to be safe with register globals */
$id =& $HTTP_GET_VARS['id'];

$sql = 'SELECT *
FROM manga
WHERE id='.$id;

/* then run the query and get the results etc... */

?>