Displaying MYSQL Data into Tables

[TeNDoLLA]

add this before running the query and paste results.

echo $query;

[Ptsface12]

The query says ; Query was empty

[TeNDoLLA]

So echo the query variable also like I said in the post above ^^. And paste the result also here. Are you sure you are actually passing the $query variable to the mysql_query() - function? Since that would produce such a error as query was empty.

 

Edit: opps, if you copied that my example there was a bug. This

$query = "UPDATE users SET username = '$user', password = '$newpass', email = '$email', nickname = '$nickname'";
$result = mysql_query($sql) or die(mysql_error());

 

Should be.

$query = "UPDATE users SET username = '$user', password = '$newpass', email = '$email', nickname = '$nickname'";
$result = mysql_query($query) or die(mysql_error());