The problem I am having is that when I visit this page (memberlist.php if you were wondering), it is blank, no HTML, nothing.

OK, fair enough, at the moment, there's nothing in the DB, so it shouldn't be displaying rows and rows of information. But, it should still display the titles of the columns (because there's no 'if' or 'where', just 'echo')

PHP Code:

<?php

$con = mysql_connect("localhost", "username", "password");
if (!$con)
  {
  die('Could not connect: ' . mysql_error());
  }

mysql_select_db("database_name", $con);

$result = mysql_query("SELECT * FROM tablename ORDER BY joined, name");

echo '<table width="100%" border="0">
  <tr>
    <td>#</td>
    <td>Name</td>
    <td>Role</td>
    <td>Joined</td>
    <td>GB Profile</td>
  </tr>';

while($row = mysql_fetch_array($result))
    {
    echo "<table>
        <tr>
            <td>$row['id']</td>
            <td>$row['name']</td>
            <td>$row['role']</td>
            <td>$row['joined']</td>
            <td>$row['gb']</td>
        </tr>
    </table>";
        
    echo "<br />";
    }
  
mysql_close($con);

?>

Are errors turned off on your php install? I don't catch anything in particular but I could be missing something.

But a few things that are incorrect. You open a table tag in your first echo and never close it, but you then open another table tag in your while statement and you close it there. It's an aweful lot of table tags to be in a long memberlist. Don't you think you should remove those tags and just close the whole table with anonther echo statment?

The only thing I can possibly think of is that echo might only work on a single line with '. Try making them " and escapting the quotes with \" and see if it echos out.

Originally Posted by AliKat

Are errors turned off on your php install? I don't catch anything in particular but I could be missing something.

But a few things that are incorrect. You open a table tag in your first echo and never close it, but you then open another table tag in your while statement and you close it there. It's an aweful lot of table tags to be in a long memberlist. Don't you think you should remove those tags and just close the whole table with anonther echo statment?

The only thing I can possibly think of is that echo might only work on a single line with '. Try making them " and escapting the quotes with \" and see if it echos out.

Thanks, you were right, php errors were turned off. I used a different server and followed the errors, it was the $_row[''] that was doing it, not sure why, but I used " instead of '

btw Gilligan.. next time you have this issue to saved you moving to another server .. just wack..

error_reporting(1)

in the top of your code to see the errors