Web Site

Collapse
This topic is closed.
X
X
 
  • Time
  • Show
Clear All
new posts
  • Tech360

    Web Site

    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-
    >fields['pack_id'];
    $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 ');
    ?>

  • ZeldorBlat

    #2
    Re: Web Site

    On May 31, 2:14 pm, Tech360 <Stamm...@gmail .comwrote:
    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->fields['pack_id'];
    >
    $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 ');
    ?>
    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).

    Comment

    Working...