I have been working all day on trying to get the drawing interface to save to a database I've created.
I followed the instructions provided with the interface and I'm not sure whether it's not working because I removed the log in section. I didn't really need the log in part because I don't need the site to work in that way. I wanted it to be an open house for anyone to draw and save.
These are the instructions I followed for setting up the two databases
CREATE TABLE paint
No int(11) NOT NULL auto_increment,
Author varchar(20) NOT NULL default '',
Picture varchar(50) NOT NULL default '',
Country varchar(12) NOT NULL default '',
sloeve longtext NOT NULL,
aloeve longtext NOT NULL,
currentRis text NOT NULL,
frucS text NOT NULL,
frucA text NOT NULL,
PRIMARY KEY (No)
) TYPE=MyISAM;
CREATE TABLE users (
Uname varchar(20) NOT NULL default '',
Upass varchar(50) NOT NULL default '',
UNIQUE KEY UserName (Uname),
UNIQUE KEY Pass (Upass)
) TYPE=MyISAM;
I think I have managed to follow the instructions but as I said I don't really need the log in database which I guess is the User table.
There is another instruction that I don't really understand either:-
INSERT INTO users VALUES ('flashkit', 'flashkit');
I wonder if this is for the log in page in order to generically log on.
I have fiddled about with this and uploaded it to the web but when I now try and save it comes back with an error about my log in.
Monday, January 21, 2008
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment