Below is just a selection from our recent portfolio of projects.
SELECT AN OPTION TO FILTER PROJECTS BY CATEGORY.
- All Projects $result=mysql_query("SELECT `id`,`name` FROM `project_types` WHERE `status` <1 ORDER BY `order`") or die (mysql_error()); while($row=mysql_fetch_array($result)) { $name = utf8_encode($row['name']); $class = nice_url($name); $type_id = $row['id']; $classes_arr[] = $class; // for use in script at bottom of page $types_arr[$type_id] = $class; // for use in generating the filter classes for this item ?> } ?>
-
$result=mysql_query("SELECT * FROM `projects` WHERE `status` < 1 ORDER BY `order` ") or die (mysql_error());
while($row=mysql_fetch_array($result))
{
$name = utf8_encode($row['name']);
$id = $row['id'];
//$desc = trim_text(stripslashes($row['description']),70);
$client = stripslashes($row['client']);
$images_arr = explode(",",$row['images']);
//$img = str_replace("/media-thu", "/media", $images_arr[0]);
$img = $images_arr[0];
//$img = str_replace("/media/","/media-thu/",$img);
$service_arr = explode(",",$row['services']);
$type_ids_arr = explode(",",$row['type_ids']);
unset($type_class_str);
foreach ($type_ids_arr as $value) {
$type_class_str .=$types_arr[$value];
}
$url = "/project/".nice_url($name)."/".$id;
?>
-
-
foreach ($service_arr as $key => $value) {
$result2=mysql_query("SELECT `id`,`name` FROM `services` WHERE `id` = $value ") or die (mysql_error());
while($row2=mysql_fetch_array($result2))
{
$s_name = strtoupper($row2['name']);
$s_id = $row2['id'];
$s_url = "/service/".nice_url($s_name)."/".$s_id;
?>
- } } ?>
VIEW PROJECT
}
?>