crayfish


Orange dwarf crayfish	Cambarellus Puer dwarf crayfish	Chocolat dwarf crayfish	Apricot crayfish

shrimp


Amano shrimp	Bee shrimp	Blue tiger shrimp	Green dwarf shrimp


Red nose shrimp	Sri lankian shrimp	White beads shrimp white pearl	Red cherry shrimp


Marble shrimp	Bristle hand shrimp	Long arm shrimp	Blue mexico shrimp


Back striped shrimp	Red - white bee shrimp	Black - white bee shrimp	Darkblue/brown Tiger dwarf shrimp

			no shrimp yet
Tiger dwarf shrimp	Orange eye tiger dwarf shrimp - multicolored	Crystal-red dwarf shrimp	no shrimp yet

Please click one of the images above to see the whole gallery.

HTMLend; }else{ defini(); $table = "wirbel_bilder"; $sqlc = "SELECT wi_b_gruppe, wi_b_URL FROM $table WHERE wi_b_id = '".$_GET["id"]."' "; $resultc=mysql_query($sqlc); $h= "0"; while($row = mysql_fetch_row($resultc)) { mysql_data_seek($resultc, $j); $myrow = mysql_fetch_array($resultc, MYSQL_ASSOC) ; $picgroup = $myrow["wi_b_gruppe"]; $picurl = $myrow["wi_b_URL"]; $h++; } $tabled = "wirbel_bilder"; $sqld = "SELECT count(*) FROM $tabled WHERE wi_b_gruppe = '".$picgroup."' "; $resultd=mysql_query($sqld); $ergd= mysql_result($resultd,0); if(!$resultd) { echo "
Fehler:
".mysql_error()."und: ".mysql_errno()."
Ende!!" ; return 0 ; } $table = "wirbel_bilder"; $qwe = mysql_list_dbs(); $sql = "SELECT *" . "FROM $table " . "WHERE wi_b_gruppe = $picgroup ORDER BY wi_b_nr"; $resultp=mysql_query($sql); $k= "0"; $done="0"; while($row = mysql_fetch_row($resultp)) { mysql_data_seek($resultp, $k); $myrow = mysql_fetch_array($resultp, MYSQL_ASSOC) ; $wi_b_id_check[$k] = $myrow["wi_b_id"]; #Aufruf, nachdem derzeitiges Bild identifiziert wurde if($done==1){ $ref2=$wi_b_id_check[$k]; $done="0"; } #Derzeitiges Bild identifizieren if($myrow["wi_b_id"]==$_GET["id"]){ #$x für LIMIT in MySQL-Abfrage $x=$k-2; #$y für $ref1 ein Bild zurück-Pfeil $y=$k-1; $ref1=$wi_b_id_check[$y]; #IdentifizierungsFlag setzen $done=1; #echo "
hallo 00!"; } #Wenn Ende nicht gesetzt das erste Bild nehmen! if(!$ref2){ #echo "
hallo 01!"; $ref2=$wi_b_id_check[$k]; } $k++; } ##Wenn Vorletzes Bild dann trotzdem 5 ausliefern $kch=$k-2; $kch2=$k-1; #echo "kk: ".$k." - ".$wi_b_id_check[$kch2]; if($id==$wi_b_id_check[$kch]){ #echo "
hallo1!"; $x=$x-1; } ##Wenn Letztes Bild dann ebenfalls 5 ausliefern if($id==$wi_b_id_check[$kch2]){ #echo "
hallo2!"; $x=$x-2; } #Wenn Anfang nicht gesetzt das letzte Bild nehmen! if(!$ref1){ #echo "
hallo3!"; $k--; $ref1=$wi_b_id_check[$k]; } #Wenn $x zu klein für LIMIT-Abfrage dann NULL (0) setzen if($x<=0){ #echo "
hallo4!"; $x=0; } echo<<

Invertebrate gallery with $ergd images

HTMLend; $table = "wirbel_bilder"; $qwe = mysql_list_dbs(); $sql = "SELECT *" . "FROM $table " . "WHERE wi_b_gruppe = $picgroup ORDER BY wi_b_nr ASC LIMIT $x,5"; $resultp=mysql_query($sql); $j= "0"; while($row = mysql_fetch_row($resultp)) { mysql_data_seek($resultp, $j); $myrow = mysql_fetch_array($resultp, MYSQL_ASSOC) ; $wi_b_id = $myrow["wi_b_id"]; $wi_b_nr = $myrow["wi_b_id"]; $wi_b_URL = $myrow["wi_b_URL"]; if($wi_b_nr==$id){ $boderstyle="solid 2px"; }else{ $boderstyle="dashed 1px"; } #$wi_b_URL=str_replace(".jpg", "_thumb.jpg",$wi_b_URL); echo<<

HTMLend; $j++; } echo "

"; if($id){ echo "

<<< back to gallery overview"; } } ?>