END; include '/home/shoesquad/public_html/products-menu.html'; print << END; if ($_GET[colorid]) { print << "; } print << END; } print <<
END; $query = "SELECT `shoematrix`.`shoematrixid` , `shoematrix`.`imagedir` , `shoematrix`.`colorid` , `shoematrix`.`attributeid` , `colors`.`description` AS `color` FROM `shoematrix` LEFT JOIN `colors` ON `colors`.`colorid`=`shoematrix`.`colorid` WHERE `styleid`='$styleid' AND `shoematrix`.`statusid`='14' AND `shoematrix`.`colorid`='$colorid'"; $result = mysql_query($query) or die ("Mysql Error = " .mysql_error()); $numrows = mysql_num_rows($result); $shoematrix = mysql_fetch_assoc($result); $images = file("/home/shoesquad/public_html$shoematrix[imagedir]/images.txt"); $sizesquery = "SELECT DISTINCT `sizes`.`description` , `sizes`.`sizeid` FROM `inventory` LEFT JOIN `sizes` ON `sizes`.`sizeid`=`inventory`.`sizeid` WHERE `inventory`.`shoematrixid`='$shoematrix[shoematrixid]' AND `inventory`.`statusid`='8' ORDER BY `sizes`.`description`"; $sizesresult = mysql_query($sizesquery) or die ("Mysql Error = " .mysql_error()); $numstock = mysql_num_rows($sizesresult); if ($numstock <= 0) { print "
Currently Out of Stock
"; }else{ print <<Sizes In Stock
END; if ($numstock > 0) { print "
Make Offer
$ 		END; if ($_GET[styleid]) { $query = "SELECT `shoematrix`.`imagedir` , `shoematrix`.`colorid` , `shoematrix`.`attributeid` FROM `shoematrix` WHERE `styleid`='$styleid' AND `shoematrix`.`statusid`='14'"; $result = mysql_query($query) or die ("Mysql Error = " .mysql_error()); $numrows = mysql_num_rows($result); if ($_GET[colorid]) { print << END; }else{ print << END; } }else{ print <<
$style[name]: $shoematrix[color]
$style[name]

$style[description]
Our Shoes

Click on a style in the green menu on the left to view that style more closely.

Check Out Some of our Shoes!
END; include '/home/shoesquad/public_html/includes/random-shoes.html'; } print <<
END; if ($_GET[styleid]) { if (!$_GET[colorid]) { print <<
END; $i = 0; while ($shoematrix = mysql_fetch_assoc($result)) { $images = file("/home/shoesquad/public_html$shoematrix[imagedir]/images.txt"); if ($i == 3 || $i == 7 || $i == 11 || $i == 15 || $i == 19) { print ""; }elseif ($i == 0 || $i == 4 || $i == 8 || $i == 12 || $i == 16) { print ""; }else{ print ""; } $i++; } print <<
 END; }elseif ($_GET[colorid]) { print <<
END; $i = 0; foreach ($images as $img) { $img = rtrim($img); if ($i == 4 || $i == 9 || $i == 14 || $i == 19) { print ""; }elseif ($i == 0 || $i == 5 || $i == 10 || $i == 15 || $i == 20) { print ""; }else{ print ""; } $i++; } print <<
 END; } } print << END; include '/home/shoesquad/public_html/footer.html'; ?>