-=harry=-

ok, cool thanks a lot. I got it. :roll:

no, I don\'t think so :oops: but I might be mistaken.. when you say column I think of a verticle column being put into the tabe. what I want to do is add a row I want to be able to add a row under genre_name varchar(32) No and I need it to be artist_id smallint(6) Null no Default 0

same old newbie jabber... I\'m just trying to teach my self mySQL and i\'ve run into a problem, i am very sure it is very simple I have my database, in my database I have tables I want to add another row to this table. This is how it currently looks (kinda): hotchson_com --->foing_genres ------->genre_id ------->genre_name This is what I am trying to do: hotchson_com --->foing_genres ------->genre_id ------->genre_name ------->artist_id this is how I am trying to do it INSERT ( artist_id smallint(6) NOT NULL default \'0\' ); it\'s not working... this is not the only statement I have attempted, I have tried many, I\'m just getting kinda tired of seeing the error screen in phpmyadmin. the only one I had any luck with was CREATE TABLE \'artist_id\' ( smallint(6) NOT NULL default \'0\' ); but this gave me hotchson_com --->artist_id --->foing_genres please help its late and I am already balding :wink: :roll: