query($sql)) { die('There was an error running the query [' . $db->error . ']'); } while ($row = $result->fetch_assoc()) { $url=$row['url']; } $sql="UPDATE `Sponsors` SET `clicks` = clicks+1 WHERE sponsorID='$id'"; $db->query($sql)or die(mysqli_error($db)); $db->commit(); if ($db->error) { printf("Errormessage: %s\n", $db->error); } header("Location: $url"); ?>