Database Creation

bsmaff

Could someone please help and create two databases for me.

I need 2 databases, I really dont have a clue about how this works but need a database using php.

The databases needed are as follows:

Users table

ID INT PRIMARY KEY
isadmin TINYINT
Name VARCHAR(255)
Username VARCHAR(255)
Password VARCHAR (255)

Events

ID INT PRIMARY KEY
Name VARCHAR(255)
Eventdate DATE
Maxtickets INT
Price FLOAT

Thanks for your help.

rincewind456

-- 
-- Table structure for table `event`
-- 

CREATE TABLE event (
  id int(11) NOT NULL,
  event_name varchar(125) NOT NULL,
  event_date date NOT NULL default '0000-00-00',
  max_tickets int(4) NOT NULL,
  price float(6,2) NOT NULL,
  PRIMARY KEY  (id)
) TYPE=MyISAM;


-- 
-- Table structure for table `users`
-- 

CREATE TABLE users (
  id int(11) NOT NULL,
  first_name varchar(45) NOT NULL,
  last_name varchar(45) NOT NULL,
  username varchar(25) NOT NULL,
  `password` varchar(50) NOT NULL,
  join_date timestamp NOT NULL,
  is_admin tinyint(4) NOT NULL,
  PRIMARY KEY  (id)
) TYPE=MyISAM;

bsmaff

How would I go about implementing them into the html code, as I dont have a clue about anything.

gszauer

You dont!
You execute the query using phpMyAdmin, phpFlashMyAdmin, or a php code (the code would look different)....
From there on you can use php to "tweek" the table's

bsmaff

What is the full php code to create this database and the code to put it into the html.

Thanks everyone for your help it has been most appreciated.