$max_display) {
$z = 1;
for ($x = 0; $x < $num_records; $x += $max_display) {
if ($x == $start) {
$pages .= "![](\"/images/page")
";
} else {
$pages .= "" .
"";
}
$z++;
}
if ($start + $max_display < $num_records) {
$next = "" .
"![](\"/images/arrow-right.gif\")
";
}
if ($start - $max_display >= 0) {
$prev = "" .
"![](\"/images/arrow-left.gif\")
";
}
$links = $prev . $pages . $next;
}
$query2 .= $type_query . $material_query . $size_query . $artist_query . $order_query . $limit_query;
//print $query2;
$result = mysql_query($query2);
$rows = mysql_num_rows($result);
if ($rows) {
$x = 0;
$per_row = 3;
while ($line = mysql_fetch_array($result, MYSQL_ASSOC)) {
$img = (empty($line[photo])) ? " " :
"" .
"![](\"/photos/product_photos/thumbs/$line[photo]\")
";
if ($x % $per_row == 0) $listings .= "";
$listings .= "| " .
"$line[title] | " .
" " . htmldecode(nl2br($line[description])) . " " .
" | " .
"$img |
| ";
$x++;
if ($x % $per_row == 0) $listings .= "
\n\n";
}
if ($x % $per_row != 0) $listings .= "\n\n";
} else {
$listings = "| No Matching Listings - Please Call for Availability |
";
}
}
$query = "SELECT * FROM subcategories WHERE cat = '6' AND searchable = 'y' ORDER BY subcat";
$result = mysql_query($query);
while ($line = mysql_fetch_array($result, MYSQL_ASSOC)) {
$types[] = "$line[ID]^$line[subcat]";
}
$query = "SELECT * FROM buckle_sizes";
$result = mysql_query($query);
while ($line = mysql_fetch_array($result, MYSQL_ASSOC)) {
$sizes[] = "$line[ID]^$line[size]";
}
$query = "SELECT * FROM buckle_materials ORDER BY material";
$result = mysql_query($query);
while ($line = mysql_fetch_array($result, MYSQL_ASSOC)) {
$materials[] = "$line[ID]^$line[material]";
}
$query = "SELECT * FROM artists ORDER BY artist";
$result = mysql_query($query);
while ($line = mysql_fetch_array($result, MYSQL_ASSOC)) {
$artists_arr[] = "$line[ID]^$line[artist]";
}
function buckle_colors($ex_color_code) {
global $colors, $buckle_size;
$color_options = "\n";
return $color_options;
}
function buckle_sizes($size_ids) {
global $sizes;
$selected = (empty($size_ids)) ? " selected" : "";
$size_str = (empty($size_ids)) ? "" : $size_ids;
$size_options = "\n";
return $size_options;
}
function buckle_types($type_id) {
global $types, $buckle_size;
$type_options = "\n";
return $type_options;
}
function buckle_materials($material_id) {
global $materials, $buckle_size;
$materials_options = "\n";
return $materials_options;
}
function artists($artist_id) {
global $artists_arr, $buckle_size;
$artists_options = "\n";
return $artists_options;
}
?>
:: Welcome to Falconhead - Boots - Belts - Buckles ::
