The Mojah Media Network

<?php
global $user;
$this_user=$user->uid;

$result = db_query("SELECT DISTINCT (n.nid), n.title
FROM node n
LEFT JOIN content_field_project_team cp ON ( n.vid = cp.vid )
LEFT JOIN content_type_project cpp ON ( cpp.vid = cp.vid )
WHERE n.type
IN ('project')
AND n.status =1
AND cp.field_project_team_uid = $this_user
AND ( cpp.field_status_value = 'working' OR cpp.field_status_value = 'alive')
ORDER by n.title");

while ($anode = db_fetch_object($result)) {
?>

<?php
}
?>
<?php
if ($user->role == 'admin') {
?>

<?php
}
?>