Select from* meerdere tabellen (Opgelost)

<?php

include("dbconnect.php"); 

$sQuery = "SELECT * FROM appz, moviez ORDER BY datum, tijd DESC LIMIT 0, 5";

$rResult = mysql_query($sQuery);

$list = '<table>
              <tr>
                   <td colspan="2">
              </tr>';
while($r = mysql_fetch_array($rResult)) {   //line 87
 $list .= '<td>&raquo;</td><td><a href="'. $r['link'] . '">'. $r['downloadnaam'] . '</a></td>';}
$list .= '</table>';

echo $list;
?>

<?php
 
include("dbconnect.php"); 
 
$sQuery = "SELECT * FROM appz, moviez ORDER BY datum, tijd DESC LIMIT 0, 5";
 
$rResult = mysql_query($sQuery);
 
$list = '<table>
              <tr>
                   <td colspan="2">
              </tr>';
while($r = mysql_fetch_array($rResult)) {   //line 87
 $list .= '<td>&raquo;</td><td><a href="'. $r['link'] . '">'. $r['downloadnaam'] . '</a></td>';}
$list .= '</table>';
 
echo $list;
?>

<?php
$sQuery = "SELECT * FROM appz AS a, moviez AS m ORDER BY m.datum, m.tijd DESC LIMIT 0, 5";
?>

<?php
$sQuery = "SELECT * FROM appz AS a, moviez AS m ORDER BY m.datum, m.tijd DESC LIMIT 0, 5";
?>

$rResult = mysql_query($sQuery) or die(mysql_error());

$rResult = mysql_query($sQuery) or die(mysql_error());