If there is a way of doing this, then it means I'll be able to have pages listing just one genre, or only the films I've rated, say, 9 or 10. I've managed to print the actual path of the reviews (see below), but am stuck here. Any help will be much appreciated, as I am still quite new to PHP.
Code: Select all
<?php
$con = mysql_connect("localhost","myuser","mypass");
if (!$con)
{
die('Could not connect: ' . mysql_error());
}
mysql_select_db("mydb", $con);
$result = mysql_query("SELECT * FROM films");
while($row = mysql_fetch_array($result))
{
print "/reviews/" . $row['name'] . ".php";
print "<br/>";
}
mysql_close($con);
?>