 |

|
|
 |
//Include database connection details
require_once('config.php');
//Connect to mysql server
$link = mysql_connect(DB_HOST, DB_USER, DB_PASSWORD);
if(!$link) {
die('Failed to connect to server: ' . mysql_error());
}
//Select database
$db = mysql_select_db(DB_DATABASE);
if(!$db) {
die("Unable to select database");
}
/*Event Day - Thursday */
$query5 = "SELECT * FROM events where event_day='thursday' and store_id='1'";
$result5 = mysql_query($query5);
$num5 = @mysql_numrows($result5);
$m = 0;
while($m < $num5)
{
$e1 = mysql_result($result5,$m,"event_name");
$e2 = mysql_result($result5,$m,"event_desc");
$e3 = mysql_result($result5,$m,"event_id");
$e4 = mysql_result($result5,$m,"status");
$e5 = mysql_result($result5,$m,"size");
$m++;
}
/*Event Day - Friday */
$query6 = "SELECT * FROM events where event_day='friday' and store_id='1'";
$result6 = mysql_query($query6);
$num6 = @mysql_numrows($result6);
$n = 0;
while($n < $num6)
{
$f1 = mysql_result($result6,$n,"event_name");
$f2 = mysql_result($result6,$n,"event_desc");
$f3 = mysql_result($result6,$n,"event_id");
$f4 = mysql_result($result6,$n,"status");
$f5 = mysql_result($result6,$n,"size");
$n++;
}
/*Event Day - Saturday */
$query7 = "SELECT * FROM events where event_day='saturday' and store_id='1'";
$result7 = mysql_query($query7);
$num7 = @mysql_numrows($result7);
$o = 0;
while($o < $num7)
{
$g1 = mysql_result($result7,$o,"event_name");
$g2 = mysql_result($result7,$o,"event_desc");
$g3 = mysql_result($result7,$o,"event_id");
$g4 = mysql_result($result7,$o,"status");
$g5 = mysql_result($result7,$o,"size");
$o++;
}
?>
if(strcmp($e4,"INACTIVE")==0 || $e4==NULL)
{
}
else { ?>
| |
Thursdays |
if($e5==0) { ?>
print $e1; ?>
print $e2; ?>
|
|
| |
} else { ?>
print $e1; ?>
print $e2; ?>
|
|
| |
} } ?>
if(strcmp($f4,"INACTIVE")==0 || $f4==NULL)
{
}
else { ?>
| |
Fridays |
if($f5==0) { ?>
print $f1; ?>
print $f2; ?>
|
|
| |
} else { ?>
print $f1; ?>
print $f2; ?>
|
|
| |
} } ?>
if(strcmp($g4,"INACTIVE")==0 || $g4==NULL)
{
}
else { ?>
| |
Saturdays |
if($g5==0) { ?>
print $g1; ?>
print $g2; ?>
|
|
| |
} else { ?>
print $g1; ?>
print $g2; ?>
|
|
| |
} } ?>
| |
18 and Up Every Night
|
| Thurs. |
9pm-2am |
| Fri. |
9pm-2am |
| Sat. |
9pm-2am |
 |
|
BAR CHARLOTTE
300 N. College St.
Charlotte, NC 28202
Phone: (704) 342-2557
|
 |
|
|
|

Fill out the form below for more information.
Silver package - Free
FREE Admission for everyone in
the party before 10:30pm
Gold Package - $50
FREE Admission for everyone in the
party before 11:30pm.
Free Bull Rides for everyone in
the Bachelorette Party.
Complimentary Souvenir BAR Bowl Party Bag with a BAR Scavenger Hunt T-Shirt.
Announcement by BAR’s DJ.
Platinum - $75
FREE Admission for everyone in the
party before 11:30pm.
Reserved table with Balloons
(need to arrive before 11pm).
Complimentary Bottle of Champagne.
FREE Bull Rides for everyone in the
Bachelorette Party!
FREE Swing Rides for everyone in the Bachelorette Party!
Party Bag with a BAR Scavenger Hunt T-Shirt.
Announcement by BAR’s DJ & Last but not least
One FREE Spanking Compliments of BAR!
|
|
| |
 |
|
 |
|
|
for ($i=0; $i<$num;$i++) {
$s1[]=mysql_result($result,$i,"event_day");
$s2[]=mysql_result($result,$i,"event_name");
$s3[]=mysql_result($result,$i,"event_desc");
$s4[]=mysql_result($result,$i,"status");
// $s5[]=mysql_result($result,$i,"event_date");
$s6[]=mysql_result($result,$i,"event_id");
$s7[]=mysql_result($result,$i,"day");
$s8[]=mysql_result($result,$i,"month");
$s9[]=mysql_result($result,$i,"year");
$s10[]=mysql_result($result,$i,"size");
if(($s4[$i]!="INACTIVE")) {
if(($s10[$i]!=0)) {
print ' ';
print '';
print '';
print ' ';
print ' ';
print 'Click here for more info';
print ' ';
print '';
print $s2[$i];
print ' ';
print '';
print $s8[$i].'/'.$s7[$i].'/'.$s9[$i];
print '';
print '';
print ' ';
}
}
}
?>
|
 |
|