MySQL?
hvordan sætter du en MySQL op på friserverplads.dk for at den virker?Min MySQL kode:
CREATE TABLE persons (
id int(6) NOT NULL auto_increment,
password varchar(15),
email varchar(255),
name varchar(100),
city varchar(30),
country varchar(30),
text longtext,
gender tinyint(1),
datetime datetime,
picturefile varchar(255),
shown int(6) default '0',
PRIMARY KEY (id)
);
CREATE TABLE hits (
pid int(6) NOT NULL default '0',
vote1 int(6) default '0',
vote2 int(6) default '0',
vote3 int(6) default '0',
vote4 int(6) default '0',
vote5 int(6) default '0',
vote6 int(6) default '0',
vote7 int(6) default '0',
vote8 int(6) default '0',
vote9 int(6) default '0',
vote10 int(6) default '0',
raters int(6) default '0',
PRIMARY KEY (pid)
);
CREATE TABLE comments (
id int(6) NOT NULL auto_increment,
pid int(6),
fromname varchar(100),
email varchar(255),
subject varchar(255),
comment longtext,
datetime datetime,
isread tinyint(1) default '0',
PRIMARY KEY (id)
);
CREATE TABLE votes (
id int(11) NOT NULL auto_increment,
sessionid varchar(20),
pid int(6),
ip varchar(15),
vote tinyint(1),
PRIMARY KEY (id)
);
CREATE TABLE shown (
id int(11) NOT NULL auto_increment,
sessionid varchar(20),
pid int(6),
ip varchar(15),
PRIMARY KEY (id)
);
CREATE TABLE admin (
username varchar(255),
password varchar(16),
adminip varchar(255)
);
Det her står at man skal sætte ind på friserverplads:
mysql_connect("localhost","<username>","<password>");
her er et link: http://system.friserverplads.dk/mysql.php
