Jag körde följande SQL sats men fick fel:
Kod:
USE Arcade_arcade;
CREATE TABLE dirs (
'id' MEDIUMINT NOT NULL AUTO_INCREMENT,
'date' date NOT NULL default '0000-00-00',
'title' varchar(50) NOT NULL default '',
'url' varchar(70) NOT NULL default '',
'comments' varchar(200) NOT NULL default '',
'pr' INT NOT NULL default '',
'submit' varchar(10) NOT NULL default '',
'submiturl' varchar(70) NOT NULL default '',
PRIMARY KEY (id)
);
INSERT INTO dirs (title, url, pr) VALUES ('Add URL-Free.com'),('http://www.addurl-free.com'),('5');
INSERT INTO dirs (title, url, pr) VALUES ('Tygo'),('http://www.tygo.com/dir/'),('6');
INSERT INTO dirs (title, url, pr) VALUES ('777 Media'),('http://www.777media.com/'),('4');
SELECT * FROM dirs ORDER BY title ASC;
Följande stod i PHPMyAdmin:
Citat:
MySQL said: Documentation
#1064 - You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near ''id' MEDIUMINT NOT NULL AUTO_INCREMENT, 'date' date NOT NULL de
|
Tacksam för snabb hjälp till en PHP nybörjare.