I'm developing a system for watching movies online and wanted to know how do I make movies that are in 2 categories listed in both categories. I'm getting to list only at first ... could anyone help?
I have the movie table on my system and there is a field called varchar(100)
category.
code:
<?php
require "conexao.php";
$cat = $_GET['cat'];
$sql = "SELECT * FROM filme WHERE categoria = '$categoria' ORDER BY nome LIMIT 10";
$qr = mysql_query($sql) or die(mysql_error());
while($aux = mysql_fetch_array($qr)){
$nome = $aux['nome'];
$img = $aux['img'];
$cate = $aux['categoria'];
$sinopse = $aux['sinopse'];
$cod = $aux['id'];
print"
<div class=\"categoria\">
<ul class=\"col-md-3\">
<li><a id=\"popover\" data-trigger=\"hover\" data-toggle=\"popover\" title=\"$nome\" data-content=\"$sinopse\" href=\"watch.php?cod=$cod\"><img src=\"images/capa/$img\" title=\"$nome\" ></a></li>
<span class=\"resto2\">Hdtv</span>
<strong class=\"text text-center\">$nome</strong>
</ul>
</div>";
}
?>
Here is the code I want to get the category and in my index I have the href
<a href="algumacoisa.php?cat=acao">
and has more categories:
<a href="algumacoisa.php?cat=aventura">
What I wanted to know and how do I list a 2 category movie as in the example filem has the category of action and adventure. How do I make it appear on the 2 pages of Action and Adventure?