-2

I'm working on a little browser game, but when I have a condition in connection to MySQLi database, it doesn't work.

In else closure it should write $name, but it doesn't.

if ($conn->connect_error){
    die("Connection failed: ".$conn->connect_error);
}

else{
    //IF CONNECTION IS GOOD, GET DATA FROM DATABASE
    $query = "SELECT name, separator, description, maintenance FROM configuration";
    $result = mysqli_query($conn, $query);
    $row = mysqli_fetch_assoc($result);

    $name = $row['name'];
    //this ↓↓↓
    echo $name;
}
Honza Sedloň
  • 358
  • 10
  • 27

2 Answers2

1

Use back ticks (``) when using reserved words.

From,

$query = "SELECT name, separator, description, maintenance FROM configuration";

To,

$query = "SELECT name, `separator`, description, maintenance FROM configuration";
Script47
  • 14,230
  • 4
  • 45
  • 66
0

Try with backticks:

$query = "SELECT name, `separator`, description, maintenance FROM configuration";
Kostas Mitsarakis
  • 4,772
  • 3
  • 23
  • 37