include("../includes/adodb/adodb.inc.php");
include("../includes/config.php");
$conn = NewADOConnection($DBType);
$conn->Connect($DBHost, $DBUser, $DBPass, $DBName);
$strSQL = "SELECT * FROM ursa_img WHERE BLN_ACTIEF=1 ORDER BY INT_NR";
$recordset =$conn->Execute($strSQL);
if ($recordset === false) die("SELECT failed
".$strSQL);
if ($recordset->recordCount() > 0 ){
while (!$recordset->EOF)
{
$STR_DIRECTORY[] = $recordset->Fields("STR_DIRECTORY");
$STR_THUMB[] = $recordset->Fields("STR_THUMB");
$STR_IMAGE[] = $recordset->Fields("STR_IMAGE");
$id[] = $recordset->Fields("id");
$recordset->MoveNext();
}
}
for ($j=0;$j
";
$outSTR .= "
";
}
?>
....
echo $outSTR ?>