", "", $_SESSION['recmsg']); } if (empty($_SESSION['fromname'])) { $fromname = ''; $fromphone = ''; $fromemail = ''; } else { $fromname = $_SESSION['fromname']; $fromphone = $_SESSION['fromphone']; $fromemail = $_SESSION['fromemail']; } if (isset($_GET['id'])) { $idprod = $_GET['id']; $prodname = $_GET['prodname']; $f = $_GET['expandable']; $idcat = $_GET['idcat']; $catname = $_GET['catname']; $idsubcat = $_GET['idsubcat']; $subcatname = $_GET['subcatname']; if (isset($_GET['idedit'])) { $editcolor = str_replace("%20", " ", $_GET['editcolor']); $editsize = str_replace("%20", " ", $_GET['editsize']); $editquantity = str_replace("%20", " ", $_GET['editquantity']); $val= $editcolor.$editsize.$editquantity; $idedit = $_GET['idedit']; $edit = 'true'; } else { $edit = 'false'; } $query="SELECT * FROM products WHERE id='$idprod'"; $result=mysql_query($query) or die ("Query failed ".mysql_error()); $num_rows = mysql_num_rows($result); $row = mysql_fetch_array($result); $idprod = $row["id"]; //$idcat = $row["idcat"]; //$idsubcat = $row["idsubcat"]; $sku = $row["sku"]; $pricereg = $row["pricereg"]; $pricesale = $row["pricesale"]; $pricewhole = $row["pricewhole"]; $onsale = $row["onsale"]; $caption = $row["caption"]; $description = $row["description"]; $sizes = $row["sizes"]; $photo1 = $row["photo1"]; $photo2 = $row["photo2"]; $photo3 = $row["photo3"]; $photo4 = $row["photo4"]; $photo5 = $row["photo5"]; $active = $row["active"]; if (empty($catname)) { $querycat="SELECT * FROM categories WHERE id='$idcat'"; $resultcat=mysql_query($querycat) or die ("Query failedcat ".mysql_error()); $rowcat = mysql_fetch_array($resultcat); $catname = $rowcat["caption"]; mysql_free_result($resultcat); } if (empty($subcatname)) { $querysubcat="SELECT * FROM subcategories WHERE id='$idsubcat'"; $resultsubcat=mysql_query($querysubcat) or die ("Query failedsubcat ".mysql_error()); $rowsubcat = mysql_fetch_array($resultsubcat); $subcatname = $rowsubcat["caption"]; mysql_free_result($resultsubcat); } if (empty($f)) { $i = '0'; $queryf="SELECT * FROM categories ORDER BY orderitem"; $resultf=mysql_query($queryf) or die ("Query failedf ".mysql_error()); while ($rowf = mysql_fetch_array($resultf)) { if ($rowf["id"] == '$idcat') { $f = $i; } $i++; } mysql_free_result($resultf); } if ($edit == 'true') { $heading .=" :: Scotto's Holiday Gifts :: Edit your selection"; } else { $heading .=" :: Scotto's Holiday Gifts :: ".$catname." :: $prodname"; } //next prod $query3="SELECT * FROM products WHERE FIND_IN_SET(idsubcat, '$idsubcat') AND FIND_IN_SET(idcat, '$idcat') AND active!='no' AND id > '$idprod' ORDER BY id ASC LIMIT 1"; $result3=mysql_query($query3) or die ("Query failed3"); $row3 = mysql_fetch_array($result3); $nextprod = $row3["id"]; $captionnext = $row3["caption"]; mysql_free_result($result3); //prev prod $query4="SELECT * FROM products WHERE FIND_IN_SET(idsubcat, '$idsubcat') AND FIND_IN_SET(idcat, '$idcat') AND active!='no' AND id < '$idprod' ORDER BY id DESC LIMIT 1"; $result4=mysql_query($query4) or die ("Query failed4"); $row4 = mysql_fetch_array($result4); $prevprod = $row4["id"]; $captionprev = $row4["caption"]; mysql_free_result($result4); $prevnext =""; if (!empty($prevprod)) { $prevnext .= 'Previous Item';} if ( (!empty($prevprod)) && (!empty($nextprod)) ) { $prevnext .= " | ";} if (!empty($nextprod)) { $prevnext .= 'Next Item';} //groups $groups = ''; $querygrp="SELECT * FROM groups WHERE FIND_IN_SET('$idprod', prods) AND active!='no' ORDER BY RAND() LIMIT 1"; $resultgrp=mysql_query($querygrp) or die ("Query failedgrp"); $rowgrp = mysql_fetch_array($resultgrp); $group = $rowgrp["prods"]; $group = explode(",", $group); foreach ($group as $value) { $value = $value; $query33="SELECT * FROM products WHERE id='$value' AND id!='$idprod' AND active!='no'"; $result33=mysql_query($query33) or die ("Query failed33"); while ($row33 = mysql_fetch_array($result33)) { $idprodgroup = $row33["id"]; $prodnamegroup = $row33["caption"]; $idcatgroup = $row33["idcat"]; $photogroup = $row33["photo1"]; $idsubcatgroup = $row33["idsubcat"]; $groups .= '
'.$prodnamegroup.'
'; } mysql_free_result($result33); } //foreach mysql_free_result($resultgrp); if (isset($_GET['photosel'])) { $photosel = $_GET['photosel']; } else { $photosel = $photo1; } $shipsel =''; $query122="SELECT * FROM shipping WHERE idprod='$idprod'"; $result122=mysql_query($query122) or die ("Query failed122 ".mysql_error()); $num_rows122 = mysql_num_rows($result122); if (!empty($num_rows122)) { $shipsel .=''; $shipsel .=""; } $colorsel =''; $colors =''; $query12="SELECT * FROM colors WHERE idprod='$idprod' AND active!='no'"; $result12=mysql_query($query12) or die ("Query failed12 ".mysql_error()); $num_rows12 = mysql_num_rows($result12); if (!empty($num_rows12)) { $colorsel .='

Color '; $colorsel .="

"; } $sizessel = ""; if (!empty($sizes)) { $sizessel .= "

Size "; $sizessel .= "

"; } if ($onsale=='yes') { $price = "$$pricesale Sale! Was $$pricereg"; } else { $price = "$$pricereg"; } $skushow = " [Ref. #$sku]"; if ($edit=='true') { $quantshow = "

Quantity

"; } else { $quantshow = "

Quantity

"; } // form variables $variables = ""; $variables .= " "; $variables .= ""; $variables .= ""; $variables .= ""; $variables .= ""; if ($onsale=='yes') { $variables .= " "; $variables .= " "; } else { $variables .= " "; $variables .= " "; } if ($edit=='true') { $variables .= " "; } $content .= '
'; if (isset($_GET['added'])) { $content .= '

The gift was added to your Gift List!

You can now add another gift or click here to view your gift list and make a payment.

'; } //table for ie6 $content .= '
'; if (!empty($photo1)) { $content .= ' '; } //table for ie6 $content .= ''; $content .="
"; $content .="

$caption - $price $skushow

$description

We ship your gift directly to the recipient with a FREE personalized greeting card!

"; if (!empty($photo1)) { $content .= ''; } if (!empty($photo2)) { $content .= ''; } if (!empty($photo3)) { $content .= ''; } if (!empty($photo4)) { $content .= ''; } if (!empty($photo5)) { $content .= ''; } //$content .= ' View Zoom'; $content .="
"; $content .= '
'; if ($idcat == '2') { $content .= '

15 delicious cookies!

'; } elseif ($idcat == '3') { $content .= '

30 delicious cookies!

'; } elseif ($idcat == '4') { $content .= '

75 delicious cookies!

'; } elseif ($idcat == '5') { $content .= '

FAT FREE COMBO! Almond + Cappuccino + Chocolate Fudge + Original Chip!

'; } //table for ie6 $content .= '
'; $content .="
$variables "; $content .="
Sky Blue
Bright Red
Deep Green



Recipient Information





*Required fields, thank you!

Sender Information





Personalized Message



$shipsel
"; if (($edit=='true')) { $content .= ""; } else { $content .= ""; } $content .= "
"; /*

*/ $content .= "
"; $content .='
You need to upgrade your Flash Player
Click here to intall latest Flash Player Close Zoom
'; /*$content .="

You may also like...

$groups
";*/ mysql_free_result($result); ?>

Home


"; print "window.location = \"categories.php\";"; print ""; } ?>