alter query - confused

[pouncer]

say my table has these 2 field:

 

name

address

 

i want to change the field names to

 

jpName

jpAddress

 

what would my alter query become in php guys?

im a bit stuck

[pouncer]

any ideas guys?

[jscix]

$change = "ALTER TABLE `tablename` CHANGE `name` `jpname` TYPE(LENGTH) NOT NULL";

[pouncer]

thanks alot bud.

 

TYPE(LENGTH)

 

whats that mean?

 

and also, cant i change both fieldnames in 1 line? r i have to have seperate queries?

[jscix]

ALTER TABLE `TABLE` CHANGE `name` `jpName` VARCHAR( 100 ) NOT NULL ,

CHANGE `address` `dpAddress` VARCHAR( 100 ) NOT NULL

[jscix]

sorry spelled it dpAddress instead of jp, but yeah. np

[pouncer]

do i have to have all that varchar NOT NULL stuff in, because thats already done when i created the fields beforehand.

 

just want to change fieldnames (nothing else)

[jscix]

no, you dont need it. was just explaining what i meant  by type/length

[pouncer]

thanks bud. so is this looking ok

 

mysql_query("ALTER TABLE `TABLE` CHANGE `name` `jpName`, CHANGE `address` `dpAddress`");

[jscix]

Yes, except `Table` should be the name of your table.

[pouncer]

hey mate, are the `` needed?

[pouncer]

it's not working bud.

 

echo "ALTER TABLE `$cat` " . $data;

$c = mysql_query("ALTER TABLE `$cat` " . $data);

 

the echo gives me:

 

ALTER TABLE `movies` CHANGE `title` `title` , CHANGE `media` `media` , CHANGE `director` `directorsssss` , CHANGE `cast` `cast` , CHANGE `description` `description`

 

..but it's not changing the director field name to directorsssss

 

even this didn't work

mysql_query("ALTER TABLE movies CHANGE director hello");

 

[jscix]

See if this query works,

 

$change = mysql_query("ALTER TABLE `movies` CHANGE `directors` `directorrrsss` VARCHAR( 100 ) NOT NULL");

 

 

If this doesnt work, I would just install phpMyAdmin ( Anytime you perform a command using their visual interface, it gives you the SQL Code, and has an option to output php formated code to use in your scripts )

[pouncer]

ok this worked:

 

mysql_query("ALTER TABLE `movies` CHANGE `directors` `hello` TEXT NOT NULL");

 

but how can i get the type of the fieldname?

becasue what if the field name is int, etc..

 

(the page im making is for admins to edit field names)