[dangmnx]

Hi, as you can see here: http://www.dangmn.net/hp/test.php

a set of data shows up in the column perfect, but the other two username and data our outside of the column, can someone look at the scripts and tell me whats wrong?

<?php
session_start();

$db = mysql_connect('localhost', 'dangmnne_dangmnx', ''); //fill in host, hostname, hostpass with your own

if (!$db)
  {
  die('Could not connect: ' . mysql_error());
  }


$db_selected = mysql_select_db('dangmnne_test', $db); //fill in DBname with your own

if (!db_selected)
{

die("cant connect");

}

$result = mysql_query("SELECT * FROM members");

print "<div>
<FONT COLOR='#000'><strong>1v1 standings</strong><br><hr>";

while($row = mysql_fetch_array($result))

  {
  print "<FONT COLOR='#000'><strong> user: </strong>" . $row['username'] . "<br></td>";
  print "<FONT COLOR='#000'><strong> record: </strong>" . $row['record'] . "<br></td>";
  print "<FONT COLOR='#000'><strong> replay: </strong>" . $row['replay'] . "<br></td>";
  print "<FONT COLOR='#000'><strong> ranked: </strong>" . $row['ranked'] . "<br></td>";
  print "<FONT COLOR='#000'><strong> points: </strong>" . $row['points'] . "<br><br></td>";
   }
  
print "</div>";

mysql_close($db);

?>

This post has been edited by dangmnx: 13 April 2009 - 06:35 PM

[CTphpnwb]

You're closing the table data fields and not opening any new ones. Try something like this:
(not tested)

print "<th>User:</th><th>Record</th><th>Replay</th><th>Ranked</th><th>Points</th><tr>";
while($row = mysql_fetch_array($result))

  {
  print "<td>" . $row['username'] . "</td>";
  print "<td>" . $row['record'] . "</td>";
  print "<td>" . $row['replay'] . "</td>";
  print "<td>" . $row['ranked'] . "</td>";
  print "<td>" . $row['points'] . "</td><tr>";
   }

[dangmnx]

thank you, works perfect now.

[Hary]

And to find these kind of errors, use the w3c html validator:
http://validator.w3.org/

Or use the Html Tidy Firefox plugin.