Portfolio of Thea Brine - Illustrator
Thea Brine - IllustratorPORTFOLIO | CLIENTS | PRINTS | CONTACT
 
"; $cquery= mysql($dbname, "select name,id from categories order by id"); while (list($name,$cid) = mysql_fetch_row($cquery)) { print " "; if ($page==""){$page=1;}; if ($cid==$page_cid){$start_limit=($page*7)-7; $query= mysql($dbname, "select id,image_thumb,title,client from pictures where subsection=$cid order by id desc limit $start_limit,7"); }else { $query= mysql($dbname, "select id,image_thumb,title,client from pictures where subsection=$cid order by id desc limit 7"); }; while (list($id,$image_thumb,$title,$client) = mysql_fetch_row($query)) { $name_query= mysql($dbname, "select name from clients where id=$client"); list($client_name) = mysql_fetch_row($name_query); $hover_text="$title - $client_name"; print ""; } $count=0; print "
"; $xquery= mysql($dbname, "select id,image_thumb from pictures where subsection=$cid order by id desc"); $num_rows=mysql_numrows($xquery); if ( $num_rows>0 ){ echo $name.'['; if ($num_rows <= 7){$numbers=1;}; if ($num_rows > 7 and $num_rows <=14){$numbers=2;}; if ($num_rows > 14 and $num_rows <=21){$numbers=3;}; if ($num_rows > 21 and $num_rows <=28){$numbers=4;}; if ($num_rows > 28 and $num_rows <=35){$numbers=5;}; if ($num_rows > 35 and $num_rows <=42){$numbers=6;}; $orig_numbers=$numbers; if ($page==""){$page=1;}; while ($numbers >0 ) { $count++; if ($orig_numbers>$numbers){print "-";}; if ($cid==$page_cid and $count==$page or $num_rows <7 and $cid==$page_cid){print "$count";} else {print "$count";}; $numbers=$numbers-1; } print "]"; }; //if ($orig_numbers > $page){$new_page=$page+1;print ".";}; print "
"; } print "
 
  Images © Thea Brine "; print date ("Y"); print"
 
"; ?>