ID

YYYY-MM-DD

Name

 

 

setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION); // Grab the list of users from the user list $sqlGetUserData = $conn->prepare("SELECT tournamentID,tournamentUID,tournamentName,tournamentDate FROM " . $tournamentDataTableName . " ORDER BY tournamentID DESC"); // Execute SQL query $sqlGetUserData->execute(); // Get results from the USERS table $results = $sqlGetUserData->fetchAll(PDO::FETCH_ASSOC); } catch (PDOException $e) { // failed connection echo "Connection failed: " . $e->getMessage(); } foreach ($results as $result) { $tournamentID = $result["tournamentID"]; $tournamentUID = $result["tournamentUID"]; $tournamentName = $result["tournamentName"]; $tournamentDate = $result["tournamentDate"]; echo "

$tournamentID

"; echo "

$tournamentDate

"; echo "

$tournamentName

"; echo "

EDIT

"; echo "

DELETE

"; echo "

"; } ?>