geen idee of dit bij databases hoort of bij php dus heb ik hem maar hier gezet.
ik probeer dus momenteel een soort film bibliotheek te maken wat aardig lukt maar nu probeer ik een eerder gedefinieerde variabele te vergelijken met een database invulling maar krijg dus de foutmelding:
Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in ... on line 461
No Files Found.
mocht iemand me kunnen helpen, bedankt op voorhand!
[code]<? php
stdhead("Movie Catalog");
$query = mysql_query("SELECT * FROM `movies` ORDER BY `id` DESC LIMIT 10");
if (mysql_num_rows($query) > 0){
while ($row = mysql_fetch_array($query)){
///layout
begin_frame("$row[name] ($row[year])");
print("<table align=center width=800 border=\"0\" cellspacing=\"0\" cellpadding=\"5\">\n");
Print("<tr><td width=150>$poster</td><td width=700>");
Print("<table align=center height=100% width=100% border=\"0\" cellspacing=\"0\" cellpadding=\"5\">\n");
Print("<tr><td width=150>year:</td><td width=100>$row[year]</td><td width=300></td></tr>");
Print("<tr><td width=150>budget:</td><td width=100>" . number_format($row[budget]) . "$</td><td width=300></td></tr>");
Print("<tr><td width=150>rating</td><td width=100>$row[rating]</td><td width=300></td></tr>");
Print("<tr><td width=150>revenue</td><td width=100>" . number_format($row[revenue]) . "$</td><td width=300></td></tr>");
Print("<tr><td width=150>runtime</td><td width=100>$row[runtime] min</td><td width=300></td></tr>");
Print("<tr><td width=150></td><td width=100></td><td width=150>$cat5 $cat4 $cat3 $cat2 $cat1</td></tr>");
Print("</table></td></tr></table>");
///torrents
$result = mysql_query("SELECT * FROM `files` WHERE `url`=`$row[imdb]`");
if (mysql_num_rows($result) > 0)
{
echo("<table border='0' cellpadding='5' cellspacing='0' class='ttable_headinner' align='center'>");
echo("<tr>");
echo("<td class='ttable_head'><strong>Name</strong></td>");
echo("<td class='ttable_head'><strong>test</strong></td>");
echo("<td class='ttable_head'><strong>test</strong></td>");
echo("</tr>");
while ($trow = mysql_fetch_array($result))
{
echo("<tr>");
echo("<td class='ttable_col1'>" . htmlspecialchars($trow["name"]) . "</td>");
echo("<td class='ttable_col2'>" . number_format($trow["test1"]) . "</td>");
echo("<td class='ttable_col1'>" . number_format($trow["test2"]) . "</td>");
echo("</tr>");
}
echo("</table>");
}
else
{
echo("<strong>No Files Found.</strong>");
}
////end///
end_frame();
}
}
?>
[code]
2.609 views