CODEWITHSUNDEEP
phpmysqlreset
Demos Demosthenous
Demos Demosthenous

Reputation: 15

ID reset in mysql

I try to reset my ID in the table events but the query("UPDATE events SET ID=".$i."WHERE ID=".$row['ID'];) always fails. Any idea why? 

//getting the whole table from mysql
$query="SELECT * FROM events";
$results=mysql_query($query);
$size=mysql_num_rows($results);
echo($size);

//drop the primary key 
$query="ALTER TABLE events DROP PRIMARY KEY";
if(!(mysql_query($query)))
        echo("Query1 failed");

//reset ID
for($i=0;$i<$size;$i++){
    $row=mysql_fetch_assoc($results);
    $query=" UPDATE events SET ID=".$i."WHERE ID=".$row['ID'];
    if(!(mysql_query($query)))
        echo("Query failed2");

}

//add primary key back to ID
$query="ALTER TABLE events ADD PRIMARY KEY (ID)";
if(!(mysql_query($query)))
        echo("Query failed3");

Upvotes: 0

Views: 94

Answers (1)

M0rtiis
M0rtiis

Reputation: 3774

You should at least add a space before WHERE

$query=" UPDATE events SET ID=".$i." WHERE ID=".$row['ID'];

Upvotes: 1

Related Questions