$sql = "UPDATE Categories SET CategoryName='Web' WHERE CategoryName='Business'"; if ( mysqli_query($connection, $sql) ) { $count = mysqli_affected_rows($connection); echo "

Updated " . $count . " rows

"; }