include "styles.inc"; include "countdays.php"; include "dbconnect.php"; $query = "SELECT * FROM EVENTS WHERE NAME = 'Mothers day' ORDER by DATE"; $result = mysql_query($query); $event_set = mysql_fetch_array($result); $event_day = substr($event_set['DATE'],-2,2); $event_month = substr($event_set['DATE'],-4,2); if (strlen($event_set['DATE'])<=5){$event_yearfix = "200".substr($event_set['DATE'],-5,1);} else {$event_yearfix = "20".substr($event_set['DATE'],0,2);} $timeinseconds=mktime(0, 0, 0, $event_month, $event_day, $event_yearfix);//next event date $epochinseconds=mktime();//time now $timedifferenceinsecs=$timeinseconds-$epochinseconds; $timeleft=time_left($timedifferenceinsecs); $timetodate=substr($timeleft,0,17); $themeitem = split(",",$event_set['THEMESET']); ?>
Products are always subject to availability at time of ordering. |
Mother's Day gift
She is always there for you...nothing beats a mother's love. This Mother's day don't just give her a thoughtless bunch of flowers like last year - send her a handcrafted Yummybunch delivered to her door for only $79 - delivery included. Order NOW for delivery this week! Poems about Mum: For everything we shared,
"To the world you might just be one person, echo $timetodate; ?> until echo $event_set['NAME']; ?> |
$prod_count = 1; if ($event_set['THEMESETCOUNT']==1){$howmanyunits="ID=".$themeitem[0];} if ($event_set['THEMESETCOUNT']==2){$howmanyunits="ID=".$themeitem[0]." or ID=".$themeitem[1];} if ($event_set['THEMESETCOUNT']==3){$howmanyunits="ID=".$themeitem[0]." or ID=".$themeitem[1]." or ID=".$themeitem[2];} if ($event_set['THEMESETCOUNT']==4){$howmanyunits="ID=".$themeitem[0]." or ID=".$themeitem[1]." or ID=".$themeitem[2]." or ID=".$themeitem[3];} if ($event_set['THEMESETCOUNT']==5){$howmanyunits="ID=".$themeitem[0]." or ID=".$themeitem[1]." or ID=".$themeitem[2]." or ID=".$themeitem[3]." or ID=".$themeitem[4];} //echo $unit[0]; //$query = "SELECT * FROM PRODUCTS WHERE ID=".$unit[0]." or ID=".$unit[1]." or ID=".$unit[2]." or ID=".$unit[3]." or ID=".$unit[4]." ORDER BY RANK DESC, NAME"; //$query = "SELECT * FROM PRODUCTS WHERE ID=".$unit[0]." or ID=".$unit[1]." or ID=".$unit[2]." or ID=".$unit[3]." or ID=".$unit[4]." ORDER BY COST, RANK"; $query = "SELECT * FROM PRODUCTS WHERE ".$howmanyunits." ORDER BY COST, RANK"; //$query = "SELECT * FROM PRODUCTS WHERE QTY >= 1 ORDER BY RANK DESC, NAME"; $result = mysql_query($query); while($prod_set = mysql_fetch_array($result)){ if ($prod_set['AVAIL']=="yes"){ $prod_origin_id[$prod_count] = $prod_set['ID']; $prodname[$prod_count] = $prod_set['NAME']; $proddesc[$prod_count] = substr($prod_set['DESCRIPTION'],0,80)."..."; $proddesclong[$prod_count] = $prod_set['DESCRIPTION']; $prodcost[$prod_count] = $prod_set['COST']; $prodimage[$prod_count] = $prod_set['IMAGE']; $prodthumb[$prod_count] = $prod_set['THUMB']; $prodavail[$prod_count] = $prod_set['AVAIL']; $prodrank[$prod_count] = $prod_set['RANK']; $prod_count++; } } $tempthemecount = 1; while(($tempthemecount<=$event_set['THEMESETCOUNT'])&&($tempthemecount<5)){ ?> echo $prodname[$tempthemecount];?> $tempthemecount++; } ?> |