Anonymous
public php v1 · immutable /* CREATE TABLE (DVDs) */ elseif ($create_table == '1') { mysql_query("CREATE TABLE DVDs ( Title VARCHAR(200) NOT NULL, Stars VARCHAR(5) NOT NULL, UNIQUE KEY (Title) ); "); $lines = file('DVDlist.txt'); sort($lines); foreach ($lines as $line) { mysql_query("INSERT INTO DVDs (Title, Stars) VALUES ('$line', '0') "); } }