Urgent help pls

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

    Urgent help pls

    Guys, i need your help. i'm getting error in my site. Someone should try my test base at http://naijatop.freehostia.com/ here is the line 35 func function resetcou()
    {
    $tdt=date("Y-m-d");
    $lrd=mysql_fetch_array(mysql_query("SELECT text FROM misc where dscr='CLR'"));

    $lrd=strtotime($lrd[0]);

    $nrd=mktime(0,0,0,date("m",$lrd)+1,date("d",$lrd), date("Y",$lrd));
    $rdt=date("Y-m-d",$nrd);
    if($rdt==$tdt)
    {
    $res=mysql_query("UPDATE sites SET hin='0',hout='0', dhits='0';");
    $res=mysql_query("UPDATE misc SET text='".$tdt."' WHERE dscr='CLR';");
    }
    }

    i'll be happy if i get fast replies on this.
    Last edited by youngbobby; 27.07.09, 01:53.

    #2
    1st, add correct sql details and connect to mysql[or localhost] server.
    sigpic

    Comment

    Working...
    X