Copy a row within same table

[phppup]

I'm trying to copy a row so that I can later update within a given table.

I'm not sure if there's a syntax error or rule error, or a missing piece but this code is not doing the job.

$sql = "INSERT INTO $table (id, company_name) 
SELECT id, company_name FROM $table WHERE id = 26";

The table has auto increment ID, but the many alterations that I've made have failed.

Guidance or solution, please.

Thanks.

[Barand]

the id is unique, so you can't insert a second id of 26.

Omit the id column from the query then the rest of the columns can be inserted (unless any are defined UNIQUE in which case you need to omit those too)

$sql = "INSERT INTO $table (company_name) 
SELECT company_name FROM $table WHERE id = 26";

You can call a lastInsertId() function to get the id of the new record.

[phppup]

Ok, it seems to be working now (so I can build out on it).

To be truthful, I had tried that (you taught me well) but your confirmation lead me to a different dumb mistake, as I was toying with this piece of code at the bottom of a PHP page and neglected to remove the line containing:

mysqli_close($con)

Therefore, there was no connection. Hence, failure.

What sort of PHP could I use to alert me and prevent this type of issue.

Note: I check the connection at the top of the page using

if($con === false){
    die("ERROR: Could not connect. " . mysqli_connect_error());
}

but it doesn't trigger (with the terminated connection in place) because $con is still valid.

Thanks for the help.

[phppup]

It seems that the auto increment for the ID prohibits use of an asterisk (to SELECT * and use everything EXCEPT  the ID in the insert).

Is there a lazy workaround (that's worthwhile)?

[Barand]

Yes, don't use select * ...

Also, there is no need to close a connection at the end of a page - php does this automatically for you.