I am getting a error at greatvideos2.co m
The code is below it has to do with the array
<?php
include("includ e/config.php");
session_start() ;
include("includ e/function.php");
# Find the vote information
$mydate= date('Y-m-d');
$sql ="select * from poll_question where start_date<='$m ydate' and
end_date>='$myd ate'";
$rs = $conn->Execute($sql );
$x=$rs->getarray();
$list=explode(" |", $x[0]['poll_answer']);
STemplate::assi gn('poll_id',$x[0]['poll_id']);
STemplate::assi gn('poll_qty',$ x[0]['poll_qty']);
STemplate::assi gn('list',$list );
//PAGING
$items_per_page =($config['rows_per_page']*$config['cols_per_page']);
$sql="SELECT * from video where type='public' and featured='yes' order
by addtime desc";
$rs = $conn->Execute($sql );
if($rs->recordcount()> 0)$users = $rs->getrows();
//END PAGING
$sql1 = "select VID, title, viewtime, vkey from video where
viewtime<>'0000-00-00 00:00:00' order by viewtime desc limit 0, ".
$config['recently_viewe d_video'];
$rs_v = $conn->execute($sql1) ;
$recent = $rs_v->getrows();
STemplate::assi gn('recent', $recent);
STemplate::assi gn('recent_tota l', count($recent)) ;
if ($_REQUEST['msg']!=""){
$msg=$_REQUEST['msg'];
}
STemplate::assi gn('err',$err);
STemplate::assi gn('msg',$msg);
STemplate::assi gn('answers',$u sers);
STemplate::assi gn('total',$rs->recordcount()) ;
$sql="SELECT * from video where type='public' order by addtime desc
limit 100";
$tags=group_tag s($sql);
STemplate::assi gn('tags',$tags );
STemplate::assi gn('head_bottom ',"homelinks.tp l");
if($config['enable_package ']=="yes" and $_SESSION['UID']!="")
{
$sql = "select * from subscriber where UID=$_SESSION[UID]";
$rs = $conn->execute($sql );
$u_info = $rs->getrows();
STemplate::assi gn('u_info', $u_info[0]);
$rs->movefirst();
$sql = "select * from package where pack_id=".$rs-
$rs = $conn->execute($sql );
$pack = $rs->getrows();
STemplate::assi gn('pack', $pack[0]);
}
STemplate::disp lay('head1.tpl' );
STemplate::disp lay('err_msg.tp l');
STemplate::disp lay('search.tpl ');
STemplate::disp lay('index.tpl' );
STemplate::disp lay('right.tpl' );
STemplate::disp lay('footer.tpl ');
?>
The code is below it has to do with the array
<?php
include("includ e/config.php");
session_start() ;
include("includ e/function.php");
# Find the vote information
$mydate= date('Y-m-d');
$sql ="select * from poll_question where start_date<='$m ydate' and
end_date>='$myd ate'";
$rs = $conn->Execute($sql );
$x=$rs->getarray();
$list=explode(" |", $x[0]['poll_answer']);
STemplate::assi gn('poll_id',$x[0]['poll_id']);
STemplate::assi gn('poll_qty',$ x[0]['poll_qty']);
STemplate::assi gn('list',$list );
//PAGING
$items_per_page =($config['rows_per_page']*$config['cols_per_page']);
$sql="SELECT * from video where type='public' and featured='yes' order
by addtime desc";
$rs = $conn->Execute($sql );
if($rs->recordcount()> 0)$users = $rs->getrows();
//END PAGING
$sql1 = "select VID, title, viewtime, vkey from video where
viewtime<>'0000-00-00 00:00:00' order by viewtime desc limit 0, ".
$config['recently_viewe d_video'];
$rs_v = $conn->execute($sql1) ;
$recent = $rs_v->getrows();
STemplate::assi gn('recent', $recent);
STemplate::assi gn('recent_tota l', count($recent)) ;
if ($_REQUEST['msg']!=""){
$msg=$_REQUEST['msg'];
}
STemplate::assi gn('err',$err);
STemplate::assi gn('msg',$msg);
STemplate::assi gn('answers',$u sers);
STemplate::assi gn('total',$rs->recordcount()) ;
$sql="SELECT * from video where type='public' order by addtime desc
limit 100";
$tags=group_tag s($sql);
STemplate::assi gn('tags',$tags );
STemplate::assi gn('head_bottom ',"homelinks.tp l");
if($config['enable_package ']=="yes" and $_SESSION['UID']!="")
{
$sql = "select * from subscriber where UID=$_SESSION[UID]";
$rs = $conn->execute($sql );
$u_info = $rs->getrows();
STemplate::assi gn('u_info', $u_info[0]);
$rs->movefirst();
$sql = "select * from package where pack_id=".$rs-
>fields['pack_id'];
$pack = $rs->getrows();
STemplate::assi gn('pack', $pack[0]);
}
STemplate::disp lay('head1.tpl' );
STemplate::disp lay('err_msg.tp l');
STemplate::disp lay('search.tpl ');
STemplate::disp lay('index.tpl' );
STemplate::disp lay('right.tpl' );
STemplate::disp lay('footer.tpl ');
?>
Comment