 |

|
|
 |
//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
|
 |
|
|
|
We
specialize in parties of all kinds. We’re especially
good at throwing the BEST BACHELORETTE parties in town. Now
matter the occasion, the size of your group, or when you want
to throw your party – call us! We will meet your party
needs!
Join us for our never-ending party:
|
| |
 |
|
 |
|
|
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 ' ';
}
}
}
?>
|
 |
|