The data records are always re-entered instead of updated

[Ingolme]

You will probably run into a syntax error because the values are not quoted.

[Elton]

https://prnt.sc/sqsjr8

[Ingolme]

From that error is looks as if you forgot to put a $ on your variable name on line 12.

[Elton]

https://prnt.sc/sqsm7i 

it seems like it works partially but it imports incorrectly

 

 

 

 

[Ingolme]

Your update query does not have a WHERE clause, so it updates every single row in the table. Use a WHERE clause to restrict the update to a particular row. See examples in the MySQL tutorial: https://www.w3schools.com/sql/sql_update.asp

[Elton]

$query = "UPDATE `$dbname` SET  name='%s', url='%s', short='%s', game='%s' WHERE name;";

 

[Ingolme]

If that works, it probably will update any row which has a name.