tests/foundation_projects.php

<?php

require_once "/home/data/httpd/eclipse-php-classes/system/dbconnection_foundation_ro.class.php";

$dbc = new DBConnectionFoundation();
$dbh = $dbc->connect();

$sql = "SELECT * FROM Projects WHERE Level <> 0 AND UrlIndex NOT LIKE ''";
$rs = mysql_query($sql, $dbh);
echo mysql_error($dbh);

while($row = mysql_fetch_assoc($rs)){
  echo $row['ProjectID']."<br>\n";
  #echo "<b>".$row['Name']."</b>|".$row['ProjectID']."|".$row['ParentProjectID']."|".$row['UrlIndex']."|".$row['UrlDownload']."<br>\n";
}

$dbc->disconnect();

$rs = null;

?>