 |

|
|
 |
//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
|
 |
|
|
|
|
Please
feel free to contact us with any questions, suggestions, or
comments. One of our staff members will contact you soon.
BAR CHARLOTTE
300 N. College St.
Charlotte, NC 28202
Phone: (704) 342-2557
|
| |
 |
|
 |
|
|
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 ' ';
}
}
}
?>
|
 |
|