Results 1 to 2 of 2

Thread: [SELF RESOLVED] Script Timing out

  1. #1

    Thread Starter
    Fanatic Member modpluz's Avatar
    Join Date
    Sep 2005
    Location
    Lag, NG
    Posts
    633

    Resolved [SELF RESOLVED] Script Timing out

    why does this code keep timing out?
    PHP Code:
    function getStep($u){
        
    $sql1 "SELECT Step FROM tblUsers WHERE User_ID=$u";
        
    $res1 mysql_query($sql1) or die("An error has occured<br>".mysql_error());
            if(
    mysql_num_rows($res1) > 0){
             while(
    $ro_w mysql_num_rows($res1)){
             
    $ms kill_null($ro_w['Step'], 0);
             }
            } else {
             
    $ms "-1";
            }
             return 
    $ms;

    Last edited by modpluz; Apr 12th, 2006 at 07:26 PM.
    If you want the rabbit to hop, move the carrot - Paul Kellerman(Prison Break)

    onError GoTo http://vbforums.com



    My Bits:
    VB6: Change Column Name in MS ACCESS

  2. #2

    Thread Starter
    Fanatic Member modpluz's Avatar
    Join Date
    Sep 2005
    Location
    Lag, NG
    Posts
    633

    Re: Script Timing out

    i figured it out; i used the function mysql_num_rows instead of mysql_fetch_array on line 5
    PHP Code:
    function getStep($u){ 
        
    $sql1 "SELECT Step FROM tblUsers WHERE User_ID=$u"
        
    $res1 mysql_query($sql1) or die("An error has occured<br>".mysql_error()); 
            if(
    mysql_num_rows($res1) > 0){ 
             while(
    $ro_w mysql_num_rows($res1)){ //instead of mysql_num_rows
             
    $ms kill_null($ro_w['Step'], 0); 
             } 
            } else { 
             
    $ms "-1"
            } 
             return 
    $ms

    and i can't beleive i cross checked this code times
    Last edited by modpluz; Apr 12th, 2006 at 07:25 PM.
    If you want the rabbit to hop, move the carrot - Paul Kellerman(Prison Break)

    onError GoTo http://vbforums.com



    My Bits:
    VB6: Change Column Name in MS ACCESS

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width