exec("CREATE TABLE IF NOT EXISTS {$table_name}(id INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, header_n TEXT, border_c TEXT, background_c TEXT, text_c TEXT, days TEXT, auto_s TEXT)"); $rows = $db->query("SELECT COUNT(*) as count FROM {$table_name}"); $row = $rows->fetchArray(); $numRows = $row['count']; if ($numRows == 0) { $db->exec("INSERT INTO {$table_name}(id, header_n, border_c, background_c, text_c, days, auto_s) VALUES('1', 'Event', '#000000', '#000000', '#ffffff', '7', '1')"); } //update call @$resU = $db->query("SELECT * FROM {$table_name} WHERE id='1'"); @$rowU=$resU->fetchArray(); if(isset($_POST['submit'])){ $db->exec("UPDATE {$table_name} SET header_n='".$_POST['header_n']."', border_c='".$_POST['border_c']."', background_c='".$_POST['background_c']."', text_c='".$_POST['text_c']."', auto_s='".$_POST['auto_s']."' WHERE id='1'"); $db->close(); header("Location: {$base_file}"); } include ('includes/header.php'); ?>

Sports Events