Game List

setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION); // Total GameList row count $query2 = "SELECT COUNT(*) FROM GameList"; $result2 = $con->prepare($query2); $result2->execute(); $row_count = $result2->fetchColumn(); printf ("Total Games in this list: %d\n ",$row_count); // GameList table creation $query = "SELECT * FROM GameList order by GameTitle asc"; // First pass - Get the column names (headers) print ""; $result = $con->query($query); //return only the first row (we only need field names) $row = $result->fetch(PDO::FETCH_ASSOC); print " "; foreach ($row as $field => $value){ print " "; } // end foreach print " "; // Second pass - Get the table data $data = $con->query($query); $data->setFetchMode(PDO::FETCH_ASSOC); foreach($data as $row){ print " "; foreach ($row as $name=>$value){ print " "; } // end field loop print " "; } // end record loop print "
$field
$value
"; } catch(PDOException $e) { echo 'ERROR: ' . $e->getMessage(); } // end try ?>