$project_title
![\"\"](\"projects/$project_id/$first_display_image\")
";
if($project_link!=""){
echo"";
}
echo"";
?>
";
$sql_select_client_query = "SELECT * FROM `clients` WHERE `id`='$project_client_id'";
$sql_select_client_result = mysql_query($sql_select_client_query);
while($row = mysql_fetch_array($sql_select_client_result))
{
$client_name = $row["client_name"];
$client_link = $row["client_link"];
}
if($project_contractor_id!=0){
$sql_select_contractor_query = "SELECT * FROM `clients` WHERE `id`='$project_contractor_id'";
$sql_select_contractor_result = mysql_query($sql_select_contractor_query);
while($row = mysql_fetch_array($sql_select_contractor_result))
{
$contractor_name = $row["client_name"];
$contractor_link = $row["client_link"];
}
}else{
$contractor_name = $client_name;
$contractor_link = $client_link;
}
$project_details = stripslashes($project_details);
$project_details = nl2br($project_details);
$today_timestamp = strtotime($today);
$project_completion_date_timestamp = strtotime($project_completion_date);
if($today_timestamp<$project_completion_date_timestamp){
$project_completion_date = "Ongoing";
}else{
$project_completion_date = date("F Y",$project_completion_date_timestamp);
}
echo"Designed For:
Contracted By:
"; //Date of Completion:
//$project_completion_date
echo"Details:
$project_details
"; ?>