'; $i++; } $sql = "SELECT DISTINCT activitytitle, activityid from ".$table."activity ORDER BY activitytitle ASC"; @ $result=mysql_query($sql,$db); $activitylist = ""; $activitylist = ""; while ($myrow=mysql_fetch_array($result)){ $activitylist.=''; } echo '
'.$safepage2.'
Postcode
Activity
Distance
'.$toplinks.'
'; ?> '.$myrow['activitytitle'].''; } $sql = "select pagename, xposition from xheading where website = '$website' and xposition < 999 AND xextra like '%left%' AND xgroup like '%".$lefttype."%' order by xposition asc"; $result=mysql_query($sql,$db); while ($myrow=mysql_fetch_array($result)) { $safepage=urlencode($myrow['pagename']); if ($myrow['pagename'] == "Log Out"){ $leftpagelinks.=''.$myrow['pagename'].''; }else{ $leftpagelinks.=''.$myrow['pagename'].''; } } //////////////IF ON SHOP DO THIS if ($p=="ecom" || $p=="ecom_home" || $p=="Shop" || $p=="prodreviews"){ $leftpagelinks = ''; $sql = "select * from ".$table."subcategory order by subcategoryposition asc"; $result=mysql_query($sql,$db); while ($myrow=mysql_fetch_array($result)) { $safepage=urlencode($myrow['subcategorytitle']); $leftpagelinks.=''.$myrow['subcategorytitle'].''; } $sql = "select pagename, xposition from xheading where website = '$website' and xposition < 999 AND xextra like '%left%' AND xgroup like '%S%' order by xposition asc"; $result=mysql_query($sql,$db); while ($myrow=mysql_fetch_array($result)) { $safepage=urlencode($myrow['pagename']); $leftpagelinks.=''.$myrow['pagename'].''; } } //////////////////////////// echo '
log in name
password
'.$leftpagelinks.'
'.$leftprodlinks.'
'; ?>
">
'; } else { $adlist.='

'; } } if (substr($p,0,4)=="ecom" || $p=="ecom_home" || $p=="prodreviews"){ $basketdetails=getbaskettotals($table); if ($sw=="fullproduct"){ $rightecomhtml='
'; } if ($basketdetails['totalproducts']==0){ $baskettxt='basket currently empty'; } else { $baskettxt=''.$basketdetails['totalprice'].' in basket'; } echo '
'.$baskettxt.'
'.$rightecomhtml.'
'; if ($p=="ecom_home"){ $sql = "select * from ".$table."product where productshowhome = 'R';"; $result = mysql_query($sql,$db); $ri = ''; while ($myrow = mysql_fetch_array($result)){ $picpath=($myrow['productpicturesmall']=="")?"nopic.gif":$myrow['productpicturesmall']; $picsize=autosize($picpath,180,100); $url = 'index.php?p=ecom&sw=fullproduct&productid='.$myrow['productid']; $ri.= '
'.$myrow['productname'].'
'.substr($myrow['productdescription'],0,100).'....read more
'; } $ri = ' '.$ri.'
Recommended Items
'; echo $ri; } } else { echo '
'.$adlist.'
'; } ?>

web design by web design by adshires.co.uk, (c) copyright 2004 all rights reserved