\"$indx\" ORDER BY indx limit 1";
}
else if($shift==2)
{
$qstr="SELECT indx, title, description FROM main_photos WHERE display_enabled AND indx<\"$indx\" ORDER BY indx DESC limit 1";
}
else
{
$qstr="SELECT indx, title, description FROM main_photos WHERE display_enabled AND indx=\"$indx\"";
}
$query=mysql_query($qstr);
if(!$query) { break; }
if(!$row=mysql_fetch_array($query))
{
if($shift==1)
{
$qstr="SELECT indx, title, description FROM main_photos WHERE display_enabled ORDER BY indx limit 1";
}
else if($shift ==2)
{
$qstr="SELECT indx, title, description FROM main_photos WHERE display_enabled ORDER BY indx DESC limit 1";
}
else
{
error("Photo $indx missing or not enabled for display");
break;
}
$query=mysql_query($qstr);
if(!$query) { break; }
if(!$row=mysql_fetch_array($query))
{
error("Photo $indx missing or not enabled for display");
break;
}
}
$indx = $row["indx"];
$title = $row["title"];
$description = $row["description"];
$title =str_replace("\\\"","\"",$title);
$description=str_replace("\\\"","\"",$description);
$bt=$purl.$indx.".jpg";
printf("
![](\"$bt\")
%s
![\"Previous\"](\"../i/arrow_l.gif\")
![\"Next\"](\"../i/arrow_r.gif\")
Photo # %d
%s
\n",$title,$indx,$description);
}
} while(0);
print mysql_error();
?>