creating tables

Gazevs

I am just getting started with php and I have just downloaded a php script and I need to know a couple of things one is:

I have this to create a table in my admin

CREATE TABLE banneradmin (
id int(11) DEFAULT '0' NOT NULL auto_increment,
adminuser varchar(15) NOT NULL,
adminpass varchar(15) NOT NULL,
PRIMARY KEY (id),
UNIQUE id (id, adminuser)
);

INSERT INTO banneradmin (id, adminuser, adminpass) VALUES (1, 'admin', 'pass');

this is where I am stuck where adminuser is do I put admin and what is the id as if I put id in the field box it comes up as an error something to do with the wrong column

I hope someone can understand what I am trying to to say and hope you can help
Thank you in advance.

hrosas

If what you want is insert a new record you only need to do:
insert into banneradmin ( adminuser, adminpass ) values ( 'admin', 'pass' );
or:
insert into banneradmin ( id, adminuser, adminpass ) values ( 0, 'admin', 'pass' );

I hope that work

Hector.

http://www.oksonora.com

Gazevs

CREATE TABLE banneradmin (
id int(11) DEFAULT '0' NOT NULL auto_increment,
adminuser varchar(15) NOT NULL,
adminpass varchar(15) NOT NULL,
PRIMARY KEY (id),
UNIQUE id (id, adminuser)
);

INSERT INTO banneradmin (id, adminuser, adminpass) VALUES (1, 'admin', 'pass');

if id=1 do I put 1 in the field area of the table or the value ie...

field type length/values attributes default
id int 11 0
adminuser var admin 15

adminpass var pass 15
id
id,adminuser 1,admin

as you can see I have not got much of an idea about the layout of where the things go as I only just started today but if I get this bit right I should be ok I hope someone can help and if anyone knows where I can get an idiots guide to php would be most welcome.
Thanks

cahva

As hrosas suggested,you dont have to insert the id number because its auto-increment.

I myself, learned PHP from one book, articles from websites and ofcourse reading the php.net(manual).

I found this: PHP for dummies. So its for dummies, not idiots 🙂. Theres also PHP and Mysql guide so check that out too.

Incubator

one small note, a basic sql rule: make sure all tables have a primary key. It is done so to avoid serious problems in the future 🙂
(was drilled into me by my instructor, so dont blame me 😉 )