problm in Staff log actions help me ????

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

    problm in Staff log actions help me ????

    hi dear


    i get a error in staff log action

    in this 2 action not work

    report for
    1»Posts

    2»Topics

    1»Posts its give error

    Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/www/mysite.info/mcppl.php on line 314

    314 lin is bold

    if($page>$num_pages)$page= $num_pages;
    $limit_start = ($page-1)*$items_per_page;
    $sql = "SELECT id, text, tid, uid, dtpost FROM ibwf_posts WHERE reported='1' ORDER BY dtpost DESC LIMIT $limit_start, $items_per_page";
    $items = mysql_query($sql);
    while ($item = mysql_fetch_array($items))
    {
    $poster = getnick_uid($item[3]);

    2»Topics gives error

    Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/www/mysite.info/mcppl.php on line 446

    446 line is bold

    if($page>$num_pages)$page= $num_pages;
    $limit_start = ($page-1)*$items_per_page;
    $sql = "SELECT id, name, text, authorid, crdate FROM ibwf_topics WHERE reported='1' ORDER BY crdate DESC LIMIT $limit_start, $items_per_page";
    $items = mysql_query($sql);
    while ($item = mysql_fetch_array($items))
    {
    $poster = getnick_uid($item[3]);

    m unbale to short out tel me where is error ?

    #2
    In both parts write
    echo mysql_error();
    after $items = mysql_query($sql);
    and post wat u get

    Comment


      #3
      @Anshul

      dear nw m getting

      You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '-5, 5' at line 1
      Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/www/mysite.info/mcppl.php on line 315 & 448

      in post action i get this error nw what i do ?

      Comment


        #4
        dont mention that. that error is showing only if there isnt anything to show. make if($changable==0){}else{href to that place}
        Nous Ne Dansos Pas, Nous Sommes Le Danse.!

        Comment

        Working...
        X