Querry runs fine on local but not on remote without error - it returns just blank page
<?php require_once('Connections/local_mysqli.php'); ?>
<?php require_once('webassist/mysqli/rsobj.php'); ?>
<?php
$Recordset3 = new WA_MySQLi_RS("Recordset3",$local_mysqli,0);
$Recordset3->setQuery("SELECT eak_nominees.`Title`, eak_nominees.`Director` FROM eak_nominees WHERE eak_nominees.katigoria_nominee LIKE 'Documentary%' ORDER BY eak_nominees.`Title` ASC");
$Recordset3->execute();
?>
<!doctype html>
<html>
<head>
<meta charset="utf-8">
<title>Untitled Document</title>
</head>
<body>
<?php
while(!$Recordset3->atEnd()) {
?>
<table>
<tbody>
<tr>
<td><?php echo($Recordset3->getColumnVal("Title")); ?> (<?php echo($Recordset3->getColumnVal("Director")); ?>)</td>
</tr>
</tbody>
</table>
<?php
$Recordset3->moveNext();
}
$Recordset3->moveFirst(); //return RS to first record
?>
</body>
</html>
thank's
/kostas
