<? // Global vars $today = strtotime("now"); $date = date("Y-m-d"); // Connect to database $servername = "localhost"; $username = "c30localfaircoop"; $password = "yya@KyDVD68"; $database = "c30localfaircoop"; $conn = new mysqli($servername, $username, $password, $database); if ($conn->connect_error) { die("Connection failed: " . $conn->connect_error); } // Update data $sql = "SELECT id FROM ln"; $result = mysqli_query($conn, $sql); while ($row = mysqli_fetch_assoc($result)) { $id = $row['id']; $icon = "img/" . $id . ".png"; // $icon = ""; //var_dump($icon); exit; $sqm = "UPDATE ln SET icon = '$icon'"; $resulu = mysqli_query($conn, $sqm); } echo "Correct!"; $conn->close(); //Close connection ?>