'')
$query = 'select `id`, `pname`, `pimage` from `zsf_products` where `group_fk` = ' . $cat . ' order by `pname`';
else
$query = 'select `id`, `pname`, `pimage` from `zsf_products` where `id` in (select `prodid_fk` from `zsf_specials` where `group_fk` = ' . $cat . ') order by `pname`';
$res = mysql_query($query, $conn);
while ($row = mysql_fetch_array($res))
{
$itemids[] = $row[0];
$products[$row[0]] = $row[1];
$imgs[$row[0]] = $row[2];
}
$prodmenu = '';
*/
$query = '
select
distinct c.`prodid_fk` pid,
p.`pname`,
p.`pimage`,
g.`gdir`
from
`zsf_products` p,
`zsf_justarrived` c,
`zsf_groups` g
where
g.`id` = p.`group_fk` and
p.`id` = c.`prodid_fk`
order by
`pname`';
$res = mysql_query($query, $conn);
while ($row = mysql_fetch_array($res))
{
$itemids[] = $row[0];
$products[$row[0]] = $row[1];
$imgs[$row[0]] = $row[2];
}
$prodmenu = '';
$key = array_search($item, $itemids);
$previd = $itemids[($key - 1)];
$nextid = $itemids[($key + 1)];
$prev = ($previd) ? '<< prev' : '<< prev';
$next = ($nextid) ? 'next >>' : 'next >>';
$query = 'select `pname`, `pimage`, `description`, `price`, `size`, `gname`, `gdir`, g.`id` from `zsf_products` p, `zsf_groups` g where p.`id` = ' . $item . ' and p.`group_fk` = g.`id`';
$res = mysql_query($query, $conn);
list ($pname, $pimage, $description, $price, $size, $gname, $gdir, $gid) = mysql_fetch_row($res);
if ($cat > 6)
{
$query = 'select `gname` from `zsf_groups` where `id` = ' . $cat;
$res = mysql_query($query, $conn);
list ($gname) = mysql_fetch_row($res);
}
if ($price == 0)
{
$query = 'select
m.qty,
m.price
from
zsf_products p,
zsf_prices m
where
p.id = ' . $item . ' and
p.price_fk = m.keyf';
$res = mysql_query($query, $conn);
while ($row = mysql_fetch_assoc($res))
{
extract($row);
$prices[$qty] = $price;
}
}
$query = 'select `sort`, `iname` from `zsf_images` where `prodid_fk` = ' . $item . ' order by sort';
$res = mysql_query($query, $conn);
while ($row = mysql_fetch_assoc($res))
{
extract($row);
$images[$sort] = $iname;
}
$query = 'select `size` is_size, `qty` is_avail from `zsf_inventory` where `prodid_fk` = ' . $item;
$res = mysql_query($query, $conn);
while ($row = mysql_fetch_assoc($res))
{
extract($row);
$is_size = ($is_size) ? $is_size : 0;
$instock[$is_size] = $is_avail;
}
$query = 'SELECT `phpsessid` pndg_sessid, `size` pndg_size, `qty` pndg_qty FROM `zsf_pending` where `prodid_fk` = ' . $item;
$res = mysql_query($query, $conn);
while ($row = mysql_fetch_assoc($res))
{
extract($row);
$pndg_size = ($pndg_size) ? $pndg_size : 0;
$pending[$pndg_size] += $pndg_qty;
if ($pndg_sessid == $_COOKIE['PHPSESSID'])
{
if ($pndg_size)
{
$basket[$pndg_size] = $pndg_qty;
}
else
{
$basket = $pndg_qty;
}
}
}
$query = 'select `size` csize, `price` cprice from `zsf_clearance` where `prodid_fk` = ' . $item . ' order by `size`';
$res = mysql_query($query, $conn);
while ($row = mysql_fetch_assoc($res))
{
extract($row);
$clearprods[$csize] = $cprice;
}
}
else
{
header('Location: ../index.html');
}
//print_arr($pending);
$enlarge = ($gdir == 'books') ? false : true;
if (is_array($basket))
{
$sizevals = array();
for ($i = 4; $i <= 24; $i += 2)
{
$sizevals[$i] = 0;
}
foreach($basket as $svsize => $svqty)
{
$svsize = ($svsize) ? $svsize : 0;
$sizevals[$svsize] = $svqty;
}
}
else
{
$sqty = ($basket) ? $basket : 0;
}
?>
StreamFlies.com / 541-218-1994
Home: ' . $gname . ': ' . $pname . '[back]' . "\n";
echo '';
echo '' . $prev . ' ' . $prodmenu . ' ' . $next . ' | ' . "\n";
echo '' . "\n";
if ($enlarge)
{
echo ' Click the image to enlarge
![' . $pname . '.jpg](/images/products/fullsize/' . $gdir . '/' . $pimage . '.jpg) ' . "\n";
}
else
{
echo '![' . $pname . '.jpg](/images/products/fullsize/' . $gdir . '/' . $pimage . '.jpg) ' . "\n";
}
if ($images)
{
echo ' ';
$imgno = 1;
foreach($images as $img)
{
echo ' ';
}
}
echo ' | ' . "\n";
echo '';
echo 'Name: ' . $pname;
if ($price > 0) { echo ' Price:'; }
if (!($prices))
{
if ($price > 0) {
echo ' $' . $price;
$iprice = $price;
}
}
else
{
if ($prices[1] > 0) {
echo ' $' . $prices[1];
$iprice = $prices[1];
}
}
if ($description) { echo 'Description: ' . $description . ' ' . "\n"; }
echo '' . "\n";
echo '[back] ' . "\n";
$img_no = mt_rand(1, 4);
?>
|
|