[SOLVED] Very basic, add a line to a table

[MadnessRed]

ok, I keep having to add lines to my database. This is a pain as I don't run it, so i keep having to bug my friend to add extra lines to it as I don't have access to the phpmyadmin.

 

anyway whilst looking through some code I saw this.

 

doquery ("DELETE FROM {{table}} WHERE `stat_type` = '2' AND `id_owner` = '".$CurAlly['id']."';",'statpoints');

 

and that made me wonder, would this code work¿

 

doquery (ALTER TABLE `game_planets` ADD `sm_grav_dome` BIGINT( 11 ) NOT NULL DEFAULT '0' AFTER `big_protection_shield` ;

 

sorry if that is a bit unclear, I know absolutely zilch about mysql. All I can tell you is that the line above adds a new line to the database, everything inside the first brackets is simply a copy past from tha code that i was asking him to execute inside the phpmyadmin.

 

any help would be great, if you need more info i will endeavor to find it

[fenway]

If by "line" you mean "field", then likely yes.

[MadnessRed]

yes, sorry i do mean feilds

 

thanks