root/elgg/trunk/mod/projects/lib/function_pending.php

<?php

/////THIS IS NOT THE WAY IT SHOULD BE DONE.  THIS IS JUST A DEMONSTRATION

// Connecting, selecting database
$dbconn = pg_connect($CFG->mp_connectionstring)
    or die('Could not connect: ' . pg_last_error());

// Performing SQL query
$owner_query = "SELECT P.id, P.name, P.description, U.username FROM project_request_project P, auth_user AS U WHERE status='R' AND U.id=P.owner_id";
$result = pg_query($owner_query) or die('Query failed: ' . pg_last_error());

$run_result .= '<div class=\"project_list\"><h2>Pending Project Requests</h2></div>';

if(pg_num_rows($result) < 1){
    $run_result .= "No pending projects.";

}else{
    // Printing results in HTML
    $run_result .= "<ul>\n";
    while ($line = pg_fetch_array($result, null, PGSQL_ASSOC)) {
        $projectname = $line['name'];
        $pid = $line['id'];
        $description = $line['description'];
        $owner = $line['username'];
        $ownerlink = "$CFG->wwwroot/$owner/";
        $approvallink = "$CFG->wwwroot../request/$pid/approve/";
        $run_result .= "<li>$projectname:</li><br/>$description<br/>Owner: <a href=\"$ownerlink\">$owner</a> <br/><a href=\"$approvallink\">Approve</a>\n";
    }
    $run_result .= "</ul>\n";
}

// Free resultset
pg_free_result($result);

// Closing connection
pg_close($dbconn);




?>