<?php

$host = "localhost"; 
$user = "fnjforms"; 
$pass = "K4YoEfgpmN9X"; 
$database = "fnjapps_forms";  

$linkID = mysql_connect($host, $user, $pass) or die("Could not connect to host."); 
mysql_select_db($database, $linkID) or die("Could not find database."); 

$id = $_GET['event_id'];

$query = "SELECT * FROM ap_form_2 WHERE element_6_1='1' AND id='$id'"; 
$resultID = mysql_query($query, $linkID) or die("Data not found."); 

//fetch the results / convert results into an array

while($rows = mysql_fetch_array($resultID)){
	$id = $rows['id'];
	$image .= "<img src='/app/calendar/image.php/". $rows['element_5'] . "?width=170&amp;image=/app/submit/data/form_2/files/" . $rows['element_5'] ."'>";
	$title = $rows['element_4'];
	$startdate = date('l, F jS Y', strtotime($rows['element_1']));
	$enddate = date('l, F jS Y', strtotime($rows['element_3']));
	$description = $rows['element_2'];
}

//if i want to loop the data elsewhere

//$events_output .= ""; 
//
//for($x = 0 ; $x < mysql_num_rows($resultID) ; $x++){ 
//    $row = mysql_fetch_assoc($resultID);
//	$events_output .= "";
//	$events_output .= "Welcome to the event detail page, " . $row['element_4'] . " ";
//    $events_output .= "";
//} 
//
//$events_output .= "\n\t\n";

//echo $events_output;
//<?php echo $events_output; ?->

mysql_close($linkID);

?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml" lang="en" xml:lang="en">
<head>
  <title>Fat and Juicy Bloody Mary Mix | F&J Event Details for <?php echo $title ?></title>
  <meta name="keywords" content="events,event,details,fat,and,juicy,fat and juicy bloody mary mix,bloody,bloody mary,bloody mary mix,mix" />
  <meta name="description" content="F&J Event Details for <?php echo $title ?>" />
  <meta name="robots" content="index, follow" />
  <meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />
  <meta name="author" content="Catoe Group" />
  <link href="/media/css/style.css" rel="stylesheet" type="text/css" />
  <link href="/media/css/superfish.css" rel="stylesheet" type="text/css" />
  <link href="/media/css/nivo.css" rel="stylesheet" type="text/css" />
  <link href="/media/css/bxslider.css" rel="stylesheet" type="text/css" />
  <link rel="stylesheet" href="/media/tools/slider/themes/fatandjuicy/fatandjuicy-small.css" type="text/css" media="screen" />
  <link rel="stylesheet" href="/media/tools/box/jquery.fancybox.css?v=2.0.5" type="text/css" media="screen" />
  <!--[if lte IE 7]><link href="/media/css/iehacks.css" rel="stylesheet" type="text/css" /><![endif]-->
  <script type="text/javascript" src="https://ajax.googleapis.com/ajax/libs/jquery/1.7.1/jquery.min.js"></script>
  <script type="text/javascript" src="https://ajax.googleapis.com/ajax/libs/jqueryui/1.8.18/jquery-ui.min.js"></script>
  <script type="text/javascript" src="/media/js/jquery.easing.1.3.js" ></script>
  <script type="text/javascript" src="/media/tools/scroll/jquery.mousewheel.min.js" ></script>
  <link href="/media/tools/scroll/jquery.mCustomScrollbar.css" rel="stylesheet" type="text/css" />
  <script type="text/javascript" src="/media/tools/scroll/jquery.mCustomScrollbar.js" ></script>
  <script type="text/javascript" src="/media/tools/scroll/scroll.js" ></script>
  <!--[if IE 6]>
  <script type="text/javascript" src="/media/js/ie6pngfix.js"></script>
  <script type="text/javascript">
    DD_belatedPNG.fix('img, ul, ol, li, div, p, a, h1, h2, h3, h4, h5, h6, span, input, textarea, td');
  </script>
  <![endif]-->
  <script type="text/javascript" src="/media/js/hoverIntent.js"></script>
  <script type="text/javascript" src="/media/js/superfish.js"></script>
  <script type="text/javascript" src="/media/js/jquery.nivo.slider.pack.js"></script>
  <script type="text/javascript" src="/media/js/jquery.bxSlider.min.js" ></script>
  <script type="text/javascript" src="/media/js/fnj.js"></script>
  <script type="text/javascript" src="/media/js/slider2.js"></script>
  <script type="text/javascript" src="/app/calendar/js/herethere.js"></script>
  <script type="text/javascript" src="/media/tools/box/jquery.fancybox.pack.js?v=2.0.5"></script>
  <script type="text/javascript" src="/media/tools/box/jquery.fancybox.execute.js"></script>
  <link rel="shortcut icon" type="image/x-icon" href="/favicon.ico">
  <style type="text/css">
  body {
      margin:0;
      padding:0;
      font-family:Arial, Helvetica, sans-serif;
      font-size:11px;
  }
  img {border:none;}
  #event-container {
      display:block;
      width:608px;
  }
  .event-img {
      float:left;
      width:177px;
	  padding-right:6px;
  }
  .event-info {
      float:left;
      width:425px;
  }
  .event-info h1{
      padding:0;
      margin:0;
  }
  .event-info p{
      /*padding:0;
      margin:0;*/
	  font-size:13px;
	  line-height: 21px;
  }
  .event-info strong {font-size:11px;}
  .event-info .share {
      width:120px;
      height:26px;
  }
  .event-info .shareicons {
      padding:10px 16px 0px 0px;
      position:relative;
  }
  .event-info .shareicons a {
      display:block;
      margin-right:4px;
      float:left;
  }
  </style>
</head>
<body>
<!-- outerwpr -->
<div class="outerwpr">

  <!-- header -->
  <div id="header">
    <div class="wpr">
    
      <!-- header bar -->
      <div class="header_top">
        <div class="top_social">
          <ul>
            <li><a href="http://www.facebook.com/fatandjuicy" class="facebook">facebook</a></li>
            <li><a href="http://www.twitter.com/fatandjuicymix" class="twitter">twitter</a></li>
            <li><a href="http://www.youtube.com/user/fatandjuicymix" class="youtube">youtube</a></li>
          </ul>
        </div>
        <div class="shopping_cart">
          <a href="/retail">SHOP ONLINE TODAY</a>
        </div>
      </div>
      <!-- / header bar -->
      
      <!-- geoiplocation -->
      <div class="geoiplocation">
        <a href="http://find.fatandjuicy.com/nearyou.html" class="various fancybox.iframe">Pick up some Fat &amp; Juicy Mix at a store near you!</a>
      </div>
      <!-- / geoiplocation -->
      
      <!-- navigation -->
      <div class="navigation">
        <div class="navigation_menu">
          <ul class="sf-menu">
            <li class="first"><a href="/index"><span>F&amp;J<br />HOME</span></a></li>
            <li><a href="/story"><span>THE STORY<br />OF F&amp;J</span></a></li>
            <li><a href="/flavor"><span>FULLY-LOADED<br />FLAVOR</span></a></li>
            <li class="spacer"><a href="/retail"><span>FIND F&amp;J<br />IN STORES</span></a></li>
            <li><a href="/press"><span>F&amp;J<br />PRESS</span></a>
              <!-- ul>
                <li><a href="">Optional Link to a Page</a></li>
                <li><a href="">Optional Link to a Page</a></li>
                <li><a href="">Optional Link to a Page</a></li>
                <li><a href="">Press Contacts</a></li>
              </ul -->
            </li>
            <li><a href="/contact"><span>CONTACT<br />F&amp;J</span></a></li>
          </ul>
        </div>
      </div>
      <!-- / navigation -->
      
      <!-- logo -->
      <div class="logo">
        <a href="/"><img src="/media/images/logo.png" alt="Home" title="Home" /></a>
      </div>
      <!-- / logo -->
    
    </div>
  </div>
  <!-- / header -->

  <!-- wrapper -->
  <div class="wpr">
  
    <!-- main body -->
    <div id="middle">
    
      <!-- left column -->
      <div id="left" class="clearingfix">
      
        <!-- sidebar slider -->
        <div class="sidebar_slider">
          <div class="slider-wrapper theme-fatandjuicy-small">
          <ul id="slider2">
          	<li><a href=""><img src="/media/images/sidebar_slider-1.jpg" alt="" /></a></li>
            <li><a href=""><img src="/media/images/sidebar_slider-2.jpg" alt="" /></a></li>
            <li><a href=""><img src="/media/images/sidebar_slider-3.jpg" alt="" /></a></li>
            <li><a href=""><img src="/media/images/sidebar_slider-4.jpg" alt="" /></a></li>
            <li><a href=""><img src="/media/images/sidebar_slider-5.jpg" alt="" /></a></li>
            <li><a href=""><img src="/media/images/sidebar_slider-6.jpg" alt="" /></a></li>
            <li><a href=""><img src="/media/images/sidebar_slider-7.jpg" alt="" /></a></li>
            <li><a href=""><img src="/media/images/sidebar_slider-8.jpg" alt="" /></a></li>
          </ul>
          </div>
        </div>
        <!-- / sidebar slider -->
        
        <!-- twitter box -->
        <div class="twitter_box" style="display:none;">
          <h3><span>F&amp;J ON TWITTER</span></h3>
          <div id="mcs3_container">
          <div class="customScrollBox">
          <div class="scrollContainer">
          <div class="scrollContent">
          <ul id="twitter_update_list_fnj_twitter"><li></li></ul>	
          <script type="text/javascript"> 
          <!--//--><![CDATA[//><!--
          function twitterCallback2(twitters) {
              var statusHTML = [];
              for (var i=0; i<twitters.length; i++){
                  var username = twitters[i].user.screen_name;
                  var status = twitters[i].text.replace(/((https?|s?ftp|ssh)\:\/\/[^"\s\<\>]*[^.,;'">\:\s\<\>\)\]\!])/g, function(url) {
                  return '<a href="'+url+'">'+url+'</a>';
                      }).replace(/\B@([_a-z0-9]+)/ig, function(reply) {
                      return  reply.charAt(0)+'<a href="http://twitter.com/'+reply.substring(1)+'">'+reply.substring(1)+'</a>';
                      });
                      statusHTML.push( '<li><span class="content">'+status+'</span> <br /><a class="ago" href="http://twitter.com/'+username+'/statuses/'+twitters[i].id_str+'">'+relative_time(twitters[i].created_at)+'</a></li>' );
                      }
                  document.getElementById( 'twitter_update_list_fnj_twitter').innerHTML = statusHTML.join( '' );
                  }
          function relative_time(time_value) {
              var values = time_value.split( " " );
                    time_value = values[1] + " " + values[2] + ", " + values[5] + " " + values[3];
                    var parsed_date = Date.parse(time_value);
                    var relative_to = (arguments.length > 1) ? arguments[1] : new Date();
                    var delta = parseInt((relative_to.getTime() - parsed_date) / 1000);
                    delta = delta + (relative_to.getTimezoneOffset() * 60);
                    if (delta < 60) {
                      return 'less than a minute ago';
                    } else if(delta < 120) {
                      return 'about a minute ago';
                    } else if(delta < (60*60)) {
                      return (parseInt(delta / 60)).toString() + ' minutes ago';
                    } else if(delta < (120*60)) {
                      return 'about an hour ago';
                    } else if(delta < (24*60*60)) {
                      return 'about ' + (parseInt(delta / 3600)).toString() + ' hours ago';
                    } else if(delta < (48*60*60)) {
                      return '1 day ago';
                    } else {
                      return (parseInt(delta / 86400)).toString() + ' days ago';
                    }
                  }
              //-->!]]>
              </script>
              <script type="text/javascript" src="http://api.twitter.com/1/statuses/user_timeline/fatandjuicymix.json?callback=twitterCallback2&amp;count=12&amp;include_rts=t"></script>
			</div>
          </div>
          <div class="dragger_container">
          <div class="dragger"></div>
          </div>
          </div>
          </div>
        </div>
        <!-- / twitter box -->
      
      </div>
      <!-- / left column -->
      
      <!-- content column -->
      <div id="main" class="clearingfix">
      
        <div class="content">
          <div id="event-container">
              <div class="event-img"><?php echo $image ?></div>
              <div class="event-info">
                  <h1><?php echo $title ?></h1>
                  <p>
                  <strong>Dates: <?php echo $startdate ?> &mdash; <?php echo $enddate ?></strong><br />
                  <?php echo $description ?>
                  <div class="share">
                      <div class="shareicons"> 
                      <a href="http://www.facebook.com/sharer.php?u=http://www.fatandjuicy.com/events-detail.php?event_id=<?php echo $id ?>&t=<?php echo $title ?>" title="facebook"><img src="/app/calendar/images/facebook-icon-evn.png" alt="facebook"></a>
                      <a href="http://twitter.com/home?status=<?php echo $title ?> http://www.fatandjuicy.com/events-detail.php?event_id=<?php echo $id ?>" title="Twitter"><img src="/app/calendar/images/twitter-icon-evn.png" alt="twitter"></a> 
                      <a href="http://www.fatandjuicy.com/app/calendar/rss.php"><img src="/app/calendar/images/rss-icon-evn.png" alt="rss"></a>
                      </div>
                      <div style="padding-top:4px;width:350px;"><a href="javascript: window.history.go(-1)" class="btns"><span>Go Back</span></a> <a href="/calendar" class="btns"><span>View Calendar</span></a></div>
                  </div>
                  </p>
              </div>
          </div>

        </div>
      
      </div>
      <!-- / content column -->
    
    </div>
    <!-- / main body -->
  
  </div>
  <!-- / wrapper -->

  <!-- footer -->
  <div id="footer">
    <div class="footer_bg">
      <div class="wpr">
      
        <div class="footer_social">
          <ul>
            <li><a href="http://www.facebook.com/fatandjuicy" class="facebook">facebook</a></li>
            <li><a href="http://www.twitter.com/fatandjuicymix" class="twitter">twitter</a></li>
            <li><a href="http://www.youtube.com/user/fatandjuicymix" class="youtube">youtube</a></li>
          </ul>
        </div>
        
        <div class="social_party">
          <h3>SEND US PICTURES OF YOUR F&amp;J</h3>
          <ul id="socialparty">
            <li><a href="/gallery"><img src="/media/images/social_party_img01.jpg" alt="" /></a></li>
            <li><a href="/gallery"><img src="/media/images/social_party_img02.jpg" alt="" /></a></li>
            <li><a href="/gallery"><img src="/media/images/social_party_img03.jpg" alt="" /></a></li>
            <li><a href="/gallery"><img src="/media/images/social_party_img04.jpg" alt="" /></a></li>
            <li><a href="/gallery"><img src="/media/images/social_party_img05.jpg" alt="" /></a></li>
            <li><a href="/gallery"><img src="/media/images/social_party_img06.jpg" alt="" /></a></li>
            <li><a href="/gallery"><img src="/media/images/social_party_img07.jpg" alt="" /></a></li>
          </ul>
          <a href="" class="prev" id="go-prev">prev</a>
          <a href="" class="next" id="go-next">next</a>
        </div>
        
        <div class="footer_logo">
          <a href="/"><img src="/media/images/bottom_logo.png" alt="" /></a>
        </div>
        
        <div class="footer_menu">
          <h3>GET SOCIAL WITH F&amp;J</h3>
          <ul>
            <li><a href="/contact">Contact Us</a></li>
            <li><a href="http://www.facebook.com/fatandjuicy">Like Us on Facebook</a></li>
            <li><a href="http://www.twitter.com/fatandjuicymix">Follow Us on Twitter</a></li>
            <li><a href="http://www.youtube.com/user/fatandjuicymix">F&amp;J TV</a></li>
          </ul>
        </div>
        
        <div class="footer_menu_right">
          <h3>Let's Work Together</h3>
          <ul>
            <li><a href="/contact">Wholesale Inquiries</a></li>
            <li><a href="/contact">Media Inquiries</a></li>
            <li><a href="/contact">Intern at F&amp;J</a></li>
            <li><a href="/downloads">Downloads</a></li>
          </ul>
        </div>
      
      </div>
    </div>
  </div>
  <!-- / footer -->

</div>
<!-- / outerwpr -->

<!-- copyright bar -->
<div id="copyright_bar">
  <div class="wpr">
  
    <div class="copyright">
      Copyright &copy; <script type="text/javascript">var today=new Date(); document.write(today.getFullYear());</script> F&amp;J Beverage Company, LLC. All rights reserved. 
    </div>
    
    <div class="credits">
      <a href="http://www.catoegroup.com"><img src="/media/images/design.png" alt="Website Design by Catoe Group" /></a>
    </div>
  
  </div>
</div>
<!-- / copyright bar -->
<script type="text/javascript">
  var _gaq = _gaq || [];
  _gaq.push(['_setAccount', 'UA-564660-68']);
  _gaq.push(['_trackPageview']);

  (function() {
    var ga = document.createElement('script'); ga.type = 'text/javascript'; ga.async = true;
    ga.src = ('https:' == document.location.protocol ? 'https://ssl' : 'http://www') + '.google-analytics.com/ga.js';
    var s = document.getElementsByTagName('script')[0]; s.parentNode.insertBefore(ga, s);
  })();
</script>
</body>
</html>