\n"; if($indx != "") { if($shift==1) { $qstr="SELECT indx, title, description FROM main_photos WHERE display_enabled AND indx>\"$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"; } print "\n"; $query=mysql_query("SELECT indx, title, description FROM main_photos WHERE display_enabled ORDER BY indx DESC"); if(!$query) { break; } while($row=mysql_fetch_array($query)) { $indx=$row["indx"]; $title=$row["title"]; $ft=$pdir."t_".$indx.".jpg"; $fb=$pdir.$indx.".jpg"; if(!file_exists($ft)) { continue; } if(!file_exists($fb)) { continue; } $st=$purl."t_".$indx.".jpg"; $bt=$purl.$indx.".jpg"; if($ccnt==$width) { print "\n"; $ccnt=0; } if($ccnt==0) { print ""; } print ""; $ccnt++; } } while(0); print mysql_error(); if(isset($connectid)) { if($connectid != 0) { mysql_close($connectid); } } ?>