|
Upcoming Productions
".time()." order by sort_date asc";
//echo $sql;
$result = mysql_query($sql);
//echo mysql_error();
//echo count($result);
$i=0;
if(mysql_num_rows($result)==0) {
echo 'Stay tuned... | ';
}
while($prod=mysql_fetch_array($result)) {
echo '';
//echo $rs['production_group'];
/////////////////////
//echo $html->link(''.$prod['Play']['title'].'',MakePlayLink($prod),array('escape'=>false, 'class'=>'play_title_link'));
//pr($prod);
$block = $prod['production_group'];
if($prod['city']!='' || $prod['state']!='' || $prod['country']!='') {
$block.= ' (';
if($prod['city']!='') {
$block.=$prod['city'];
}
if($prod['city']!='' && $prod['state']!='') {
$block.=', '.$prod['state'];
} else {
$block.=$prod['state'];
}
if($prod['country']!='' && (strtoupper($prod['country'])!='USA' && strtoupper($prod['country'])!='UNITED STATES')) {
if($prod['state']!='' || $prod['city']!='') {
$block.=', '.$prod['country'];
} else {
$block.=$prod['country'];
}
}
$block.= ')';
}
if($prod['event_date']!='') {
$block.=', '.$prod['event_date'];
}
if($prod['description']!='' && ord($prod['description'])!=60) {
$block.=' '.$prod['description'];
}
echo $block;
/////////////////////
echo ' | ';
$i++;
if($i==2) {
echo ' ';
$i=0;
}
}
//echo "done";
?>
Past Productions
There are no past productions.';
}
while($prod=mysql_fetch_array($result)) {
echo '';
//echo $rs['production_group'];
/////////////////////
//echo $html->link(''.$prod['Play']['title'].'',MakePlayLink($prod),array('escape'=>false, 'class'=>'play_title_link'));
//pr($prod);
$block = $prod['production_group'];
if($prod['city']!='' || $prod['state']!='' || $prod['country']!='') {
$block.= ' (';
if($prod['city']!='') {
$block.=$prod['city'];
}
if($prod['city']!='' && $prod['state']!='') {
$block.=', '.$prod['state'];
} else {
$block.=$prod['state'];
}
if($prod['country']!='' && (strtoupper($prod['country'])!='USA' && strtoupper($prod['country'])!='UNITED STATES')) {
if($prod['state']!='' || $prod['city']!='') {
$block.=', '.$prod['country'];
} else {
$block.=$prod['country'];
}
}
$block.= ')';
}
if($prod['event_date']!='') {
$block.=', '.$prod['event_date'];
}
if($prod['description']!='' && ord($prod['description'])!=60) {
$block.=' '.$prod['description'];
}
echo $block;
/////////////////////
echo ' | ';
$i++;
if($i==2) {
echo ' ';
$i=0;
}
}
mysql_close();
//echo "done";
?>
|