Recent Work
$sql_select_recent_work_query = "SELECT * FROM `projects` WHERE `displayable`='Yes' ORDER BY `id` DESC";
$sql_select_recent_work_result = mysql_query($sql_select_recent_work_query);
while($row = mysql_fetch_array($sql_select_recent_work_result))
{
$project_id = $row["id"];
$project_title = $row["project_title"];
$project_display_image = $row["project_display_image"];
$project_client_id = $row["project_client_id"];
$project_contractor_id = $row["project_contractor_id"];
$project_completion_date = $row["project_completion_date"];
$project_details = $row["project_details"];
$project_link = $row["project_link"];
$project_category = $row["project_category"];
$project_details = stripslashes($project_details);
$project_details = nl2br($project_details);
if (strlen($project_details) > 160){
$project_details = substr($project_details, 0, 157) . '...';
}
echo"
";
}
?>