0){ if($head_count==0) { //$dbsql_head = "select cat1.categorie_id, cat1.hoofd_categorie_id, cat1.titel from categorie as cat1 left join categorie as cat2 on cat1.categorie_id = cat2.hoofd_categorie_id where cat2.categorie_id = ".$categorie_id; $dbsql_head = "select cat1.categorie_id, cat1.hoofd_categorie_id, cat1.titel from categorie as cat1, categorie2 as cat2 where cat1.categorie_id = cat2.hoofd_categorie_id and cat2.categorie_id = ".$categorie_id; }else { //$dbsql_head = "select cat1.categorie_id, cat1.hoofd_categorie_id, cat1.titel from categorie as cat1 left join categorie as cat2 on cat1.categorie_id = cat2.hoofd_categorie_id where cat2.categorie_id = ".$head_array[$head_count-1][0]; $dbsql_head = "select cat1.categorie_id, cat1.hoofd_categorie_id, cat1.titel from categorie as cat1, categorie2 as cat2 where cat1.categorie_id = cat2.hoofd_categorie_id and cat2.categorie_id = ".$head_array[$head_count-1][0]; } $dbconn_head = mysql_connect($dbhost,$dbuserlogin,$dbpassword) or die("Server Unavailable"); mysql_select_db($dbname,$dbconn_head) or die("Database Unavailable"); $result1 = mysql_query($dbsql_head); if (!$result1) { echo 'Could not run query: ' . mysql_error(); exit; } $iRows = mysql_num_rows($result1); $iCols = mysql_num_fields($result1); for($row=0+$head_count ; $row<$iRows+$head_count; $row++){ $rs = mysql_fetch_row($result1); for($col=0; $col<$iCols; $col++){ $head_array[$row][$col] = $rs[$col]; }; }; mysql_free_result($result1); mysql_close($dbconn_head); $head_count++; } $dbsql_categorie_name = "select titel from categorie where categorie_id = ".$categorie_id; $categorie_name = nas_mysql_result ($dbhost,$dbuserlogin,$dbpassword,$dbname,$dbsql_categorie_name,"byindex"); echo ""; echo ""; echo "Buy Page for Posters - ".$categorie_name[0][0].""; echo ''; echo ''; echo ''; echo ''; echo ''; echo ''; echo ''; echo ''; echo ''; echo ''; echo ''; echo ""; echo ""; echo ''; $dbconn_count = mysql_connect($dbhost,$dbuserlogin,$dbpassword) or die("Server Unavailable"); mysql_select_db($dbname,$dbconn_count) or die("Database Unavailable"); $num_rows = mysql_result(mysql_query("select count(*) from product_categorie, product where categorie_id = ".$categorie_id." and product_categorie.productnumber = product.productnumber"),0); mysql_close($dbconn_count); include("paginator/include/paginator.php"); include("paginator/include/paginator_html.php"); $a =& new Paginator_html($_GET['page'],$num_rows,$categorie_id); $a->set_Limit(40); $a->set_CategorieId($categorie_id); $tot_pages = $a->getTotalPages(); //$a->set_Links($tot_pages); $a->set_Links(25); $limit1 = $a->getRange1(); $limit2 = $a->getRange2(); $dbsql = "select artist,canbeframed,canbemounted,dateadded,directory,filename,imageheight,imageurl,imagewidth,listprice,ourprice,productheight,productlink,producttype,productwidth,quickframeable,product.rank,thumbnailheight,thumbnailwidth, product.productnumber,product.title,framedlink,mountedlink from product_categorie, product where categorie_id = ".$categorie_id." and product_categorie.productnumber = product.productnumber LIMIT $limit1,$limit2"; $dbsql_subc = "select categorie_id, titel from categorie where hoofd_categorie_id = ".$categorie_id." order by titel"; $dbconn = mysql_connect($dbhost,$dbuserlogin,$dbpassword) or die("Server Unavailable"); mysql_select_db($dbname,$dbconn) or die("Database Unavailable"); $result = mysql_query($dbsql); $iRows = mysql_num_rows($result); $iCols = mysql_num_fields($result); settype($myarray,"array"); for($row=0 ; $row<$iRows; $row++){ $rs = mysql_fetch_row($result); for($col=0; $col<$iCols; $col++){ $myarray[$row + $limit1][$col] = $rs[$col]; }; }; mysql_free_result($result); mysql_close($dbconn); //-- by field index -- //$myarray = nas_mysql_result ($dbhost,$dbuserlogin,$dbpassword,$dbname,$dbsql,"byindex",$limit1); $subc_array = nas_mysql_result ($dbhost,$dbuserlogin,$dbpassword,$dbname,$dbsql_subc,"byindex"); echo "
"; echo "
"; echo "
"; echo "
"; echo "
"; echo "
"; echo "
"; echo '
'; echo ''; echo ' '; echo ''; echo ""; echo ''; echo ''; echo ""; echo "
Navigation from '.$categorie_name[0][0].'
 
"; echo ''; for($i=0; $i < count($subc_array); $i++) { echo ''; echo ''; echo ''; // echo ''; $i++; echo ''; echo ''; $i++; echo ''; echo ''; $i++; echo ''; echo ''; echo ''; }; echo '
    
'; echo '
'; $cat_rows = round(count($subc_array) / 4); for($i=0; $i < $cat_rows; $i++) { echo "
"; }; echo ''; echo ""; echo '"; echo ""; echo "
'.$a->previousNext().'
Total Pages:'.$tot_pages; //echo '
'; //echo ' Name:
'; //echo ' Email:
'; //echo ' '; //echo '
'; echo '
'; echo ''; echo '
Search For Posters!
'; echo ''; echo '
'; echo "
"; echo ''; for($i=$limit1; $i < $limit1 + $limit2; $i++) { echo ""; echo '"; $i++; echo '"; $i++; echo '"; $i++; echo '"; echo ""; }; echo "
'.$myarray[$i][20].'
'; echo ''.$myarray[$i][20].'
'; echo ''.$myarray[$i][14].' x '.$myarray[$i][11].' inches
'; //Size echo "$ ".number_format($myarray[$i][9], 2, '.', '')."
"; echo 'Buy now
'; if($myarray[$i][1]=="Y") { echo 'unframed
'; echo 'framed
'; }; if($myarray[$i][2]=="Y") { echo 'mounted
'; }; echo "		'.$myarray[$i][20].'
'; echo ''.$myarray[$i][20].'
'; echo ''.$myarray[$i][14].' x '.$myarray[$i][11].' inches
'; echo "$ ".number_format($myarray[$i][9], 2, '.', '')."
"; echo 'Buy now
'; if($myarray[$i][1]=="Y") { echo 'unframed
'; echo 'framed
'; }; if($myarray[$i][2]=="Y") { echo 'mounted
'; }; echo "		'.$myarray[$i][20].'
'; echo ''.$myarray[$i][20].'
'; echo ''.$myarray[$i][14].' x '.$myarray[$i][11].' inches
'; echo "$ ".number_format($myarray[$i][9], 2, '.', '')."
"; echo 'Buy now
'; if($myarray[$i][1]=="Y") { echo 'unframed
'; echo 'framed
'; }; if($myarray[$i][2]=="Y") { echo 'mounted
'; }; echo "		'.$myarray[$i][20].'
'; echo ''.$myarray[$i][20].'
'; echo ''.$myarray[$i][14].' x '.$myarray[$i][11].' inches
'; echo "$ ".number_format($myarray[$i][9], 2, '.', '')."
"; echo 'Buy now
'; if($myarray[$i][1]=="Y") { echo 'unframed
'; echo 'framed
'; }; if($myarray[$i][2]=="Y") { echo 'mounted
'; }; echo "
"; echo "
".$a->previousNext()."
"; echo " Total Pages:" . $tot_pages . "

"; ?>
Click here to buy Lord of the Rings posters!

Other sites: Art Prints, Movie Posters, Music Posters, Photography Posters, Framed Posters, Vintage Posters, Affiliate Poster Scripts, Iwantitcheap Shop, Book Reviews
Copyright © .com 2002-2005 All rights reserved.