[RESOLVED] mysql_fetch_object doesn't seem to work

[Staggy11]

The following code doesn't work. $query is fine, but $query2 doesn't seem to work. Does anyone know why?

$name = $_SESSION['username'];

$query = mysql_query("SELECT * FROM players WHERE username ='.$name.'") or die(mysql_error());

$query2 = mysql_fetch_object($query);

[tsinka]

Hi,

the SELECT query doesn't look ok to me. I think it should look like

"SELECT * FROM players WHERE username ='".$name."'"

The original query will hardly return anything because it searches for records where username='.$name.' including the periods.

So the fetch_object command returns nothing.

the next step after executing the query could look like

if ($objRow = mysql_fetch_object($query)) {
  echo "Name: ".$objRow->username."<br>\n";
} else {
  echo "No user found with username: ".$name."<br>\n";
}

Thomas

[Staggy11]

You were right about the SELECT query. Thanks.

This is one of the things that annoys me about PHP; the niggling little details like this that casuse such problems.