 |

|
|
 |
//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
|
 |
|
|
|
NOW HIRING FOR:
Bartenders, Barbacks, Shooter Girls,
Beer Tub Girls, Swing Girls,
Security, Entertainers,
Promoters, Management
Apply in person Monday-Wednesday
1pm-4pm or call 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 ' ';
}
}
}
?>
|
 |
|