fveNSsu0

1<?php
2$dbhost = 'localhost:3036';
3$dbuser = 'root';
4$dbpass = 'anthony';
5$conn = mysql_connect($dbhost, $dbuser, $dbpass);
6if(! $conn )
7{
8  die('Could not connect: ' . mysql_error());
9}
10echo 'Connected successfully<br />';
11$sql = "CREATE TABLE IF NOT EXISTS message_tbl( ".
12       "message_id INT NOT NULL AUTO_INCREMENT, ".
13       "message_name VARCHAR(50) NOT NULL, ".
14       "message_subject VARCHAR(40) NOT NULL, ".
15       "message_text VARCHAR(500) NOT NULL, ".
16       "message_amount INT(10) NOT NULL, ".
17       "message_die VARCHAR(10) NOT NULL, ".
18       "message_modifier INT(10) NOT NULL, ".
19       "message_roll INT(10) NOT NULL, ".
20       "PRIMARY KEY ( tutorial_id )); ";
21mysql_select_db( 'TUTORIALS' );
22$retval = mysql_query( $sql, $conn );
23if(! $retval )
24{
25  die('Could not create table: ' . mysql_error());
26}
27echo "Table created successfullyn";
28mysql_close($conn);
29?>