while not working

Discussion in 'PHP' started by promotingspace.net, Sep 5, 2009.

  1. #1
    Hi
    I have a while loop for displaying database rows
    It works in all servers but not in one of the servers (that we need)
    No data is displayed. database connection is ok just while loops are not working on that host
    How can I fix it if I don't want to change host?
    This is the code:
    while($row=mysql_fetch_object($rows)){
    $id=$row->id;
    $name=$row->rname;
    $location=$row->rloc;
    $date=rdate($row->date,'');
    
    $link="../interview.php?id=".$id;
    $name="<a href='$link'>$name</a>";
    
    $dellink="interview.php?view=all&delete=".$id;
    $delete="<a href='$dellink'>Delete</a>";
    
    $editlink="editinterview.php?edit=".$id;
    $edit="<a href='$editlink'>Edit</a>";
    
     echo "<tr><td><b> $name    </b></td><td>$location  </td><td>$date  </td><td>$edit  </td><td>$delete  </td></tr>";
    
    }
    
    Code (markup):
    also tried
    
    while($row=mysql_fetch_assoc($rows)){
    
    $id=$row['id'];
    $name=$row['rname'];
    $location=$row['rloc'];
    $date=rdate($row['date'],'');
    $link="../interview.php?id=".$id;
    $name="<a href='$link'>$name</a>";
    
    $dellink="interview.php?view=all&delete=".$id;
    $delete="<a href='$dellink'>Delete</a>";
    
    $editlink="editinterview.php?edit=".$id;
    $edit="<a href='$editlink'>Edit</a>";
    
     echo "<tr><td><b> $name    </b></td><td>$location  </td><td>$date  </td><td>$edit  </td><td>$delete  </td></tr>";
    
    }
    
    Code (markup):

     
    promotingspace.net, Sep 5, 2009 IP
  2. katanasov

    katanasov Member

    Messages:
    87
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    41
    #2
    write
    var_dump($rows);
    before while to see what is variable content
     
    katanasov, Sep 5, 2009 IP
  3. Martinoes

    Martinoes Peon

    Messages:
    110
    Likes Received:
    2
    Best Answers:
    0
    Trophy Points:
    0
    #3
    Maybe table you are using in your sql query on this server is simply empty ??
     
    Martinoes, Sep 5, 2009 IP