if($page < 1) $page = 1;
$perpage = 10;
$numrow_result = mysql_query("select id from s3_projects");
$numrows=mysql_num_rows($numrow_result);
$numpages = ceil($numrows/$perpage);
$ulimit = $perpage*$page;
$llimit = $ulimit-$perpage;
$proj_result= mysql_query("select Title, Content, Client, Site, Link, Image, id from s3_projects order by Date desc limit $llimit, $ulimit")
or die("Error retrieving projects: ". mysql_error() );
while(list($title, $content, $client, $site, $link, $image, $id) = mysql_fetch_array($proj_result) ){
$content = nl2br($content);
echo "
| Brief: | $title |
";
if($site != "") echo "
| Site: | $site |
";
if($client != "") echo "
| Client: | $client |
";
echo " |
$content ";
if($link != "") echo "
More Info";
echo " |
|
";
if($image != ""){
/* if(file_exists("../".$item_data["Image"])){
$imageInfo = getimagesize($image);
$width = $imageInfo[0];
$height = $imageInfo[1];
}*/
echo " ";
}
echo " |
";
}
?> |