0){
$que = "SELECT DISTINCT movies.movie_name, schedule.location, schedule.subtitle, schedule.three_d, movies.movie_id FROM schedule, movies WHERE schedule.movie_id=movies.movie_id AND schedule.location='".$loc."' ORDER BY schedule.movie_name ";
$locurl = "&loc=".$loc;
}elseif($loc == ''){
$que = "SELECT DISTINCT movies.movie_name, movies.movie_id FROM schedule, movies WHERE schedule.movie_id=movies.movie_id ORDER BY schedule.movie_name ";
}
if($loc == '1'){
$location = "@ Renaissance";
}
if($loc == '2'){
$location = "@ Paseo Herencia";
}
if($loc == '3'){
$location = "@ Crystal Theater";
}
?>
$chars) {
$string = substr($string, 0, $chars);
$trunc_at = strrpos($string, ' ');
if($trunc_at !== FALSE)
$string = substr($string, 0, $trunc_at);
$string = $string.$append;
}
return $string;
}
//query which fetches the movies that are currently playing at The Cinemas
$sql_selectname = $que;
$resultname = mysql_query($sql_selectname)
or die(mysql_error());
while ($row = mysql_fetch_object($resultname)){
$name = $row->movie_name;
$id = $row->movie_id;
$poster = $row->movie_id;
$type = $row->three_d;
$sub = $row->subtitle;
if($type == "1"){$add = "";}
switch ($sub) {
case "1":
$add .= "";
break;
case "2":
$add .= "";
break;
case "3":
$add .= "";
break;
}
echo "- ". truncate($name,35) ." ".$add."
";
$add = '';
$type= '';
}
include '../db_connect/maincinemas_db_disconnect.php';
?>