bugs/php/project.php

<?php
	require_once(realpath(dirname(__FILE__)).'/config.php');
	require_once(PATH_PHP.'database.php');
	global $mysqli;
	function projectObj($id){
		if($res = query("SELECT p.title,p.id,p.description,u.name as user FROM `projects` p JOIN `users` u ON u.id = p.u_id  WHERE p.id='%d'",Array($id))){
			if($res->num_rows == 1){
				$project = $res->fetch_assoc();
				$project['user'] = userObj($project['user']);
				return $project;
			}
		}
		return false;
	}
?>