By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,192 Members | 1,253 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,192 IT Pros & Developers. It's quick & easy.

Web Site

P: n/a
I am getting a error at greatvideos2.com

The code is below it has to do with the array

<?php
include("include/config.php");
session_start();
include("include/function.php");

# Find the vote information
$mydate= date('Y-m-d');
$sql ="select * from poll_question where start_date<='$mydate' and
end_date>='$mydate'";
$rs = $conn->Execute($sql);
$x=$rs->getarray();
$list=explode("|", $x[0]['poll_answer']);
STemplate::assign('poll_id',$x[0]['poll_id']);
STemplate::assign('poll_qty',$x[0]['poll_qty']);
STemplate::assign('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_viewed_video'];
$rs_v = $conn->execute($sql1);
$recent = $rs_v->getrows();
STemplate::assign('recent', $recent);
STemplate::assign('recent_total', count($recent));

if ($_REQUEST['msg']!=""){
$msg=$_REQUEST['msg'];
}

STemplate::assign('err',$err);
STemplate::assign('msg',$msg);
STemplate::assign('answers',$users);
STemplate::assign('total',$rs->recordcount());
$sql="SELECT * from video where type='public' order by addtime desc
limit 100";
$tags=group_tags($sql);
STemplate::assign('tags',$tags);
STemplate::assign('head_bottom',"homelinks.tpl");

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::assign('u_info', $u_info[0]);
$rs->movefirst();

$sql = "select * from package where pack_id=".$rs-
>fields['pack_id'];
$rs = $conn->execute($sql);
$pack = $rs->getrows();
STemplate::assign('pack', $pack[0]);
}

STemplate::display('head1.tpl');
STemplate::display('err_msg.tpl');
STemplate::display('search.tpl');
STemplate::display('index.tpl');
STemplate::display('right.tpl');
STemplate::display('footer.tpl');
?>

May 31 '07 #1
Share this Question
Share on Google+
1 Reply


P: n/a
On May 31, 2:14 pm, Tech360 <Stamm...@gmail.comwrote:
I am getting a error at greatvideos2.com

The code is below it has to do with the array

<?php
include("include/config.php");
session_start();
include("include/function.php");

# Find the vote information
$mydate= date('Y-m-d');
$sql ="select * from poll_question where start_date<='$mydate' and
end_date>='$mydate'";
$rs = $conn->Execute($sql);
$x=$rs->getarray();
$list=explode("|", $x[0]['poll_answer']);
STemplate::assign('poll_id',$x[0]['poll_id']);
STemplate::assign('poll_qty',$x[0]['poll_qty']);
STemplate::assign('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_viewed_video'];
$rs_v = $conn->execute($sql1);
$recent = $rs_v->getrows();
STemplate::assign('recent', $recent);
STemplate::assign('recent_total', count($recent));

if ($_REQUEST['msg']!=""){
$msg=$_REQUEST['msg'];

}

STemplate::assign('err',$err);
STemplate::assign('msg',$msg);
STemplate::assign('answers',$users);
STemplate::assign('total',$rs->recordcount());
$sql="SELECT * from video where type='public' order by addtime desc
limit 100";
$tags=group_tags($sql);
STemplate::assign('tags',$tags);
STemplate::assign('head_bottom',"homelinks.tpl");

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::assign('u_info', $u_info[0]);
$rs->movefirst();

$sql = "select * from package where pack_id=".$rs->fields['pack_id'];

$rs = $conn->execute($sql);
$pack = $rs->getrows();
STemplate::assign('pack', $pack[0]);

}

STemplate::display('head1.tpl');
STemplate::display('err_msg.tpl');
STemplate::display('search.tpl');
STemplate::display('index.tpl');
STemplate::display('right.tpl');
STemplate::display('footer.tpl');
?>
This line:

$rs = $conn->Execute($sql);

is not returning an object. Try a var_dump() on $rs and see what it
really is (if I had to guess it's probably boolean false).

May 31 '07 #2

This discussion thread is closed

Replies have been disabled for this discussion.