include 'includes/dbconnect.inc.php'; ?>
include 'includes/top.inc.php'; ?>
include 'includes/header.inc.php'; ?>
if (empty($_SESSION['recmsg'])) {
$cardmsg = '
Dear Customer,
During the Holiday Season more than ever, our thoughts turn gratefully to those who have made our progress possible. And in this spirit we say, simply but sincerely...
Thank You, Best Wishes and a Happy New Year.
Sincerely,
ABC';
} else {
$cardmsg = str_replace("
", "", $_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 .= '
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 .= '
| ';
$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 ($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 .= ' |