...More mySQL Questions - How do I...

[gengar003]

... How do I change the name of a field in a table, say, from "likescheese" to "likesmilk" ?

[Gary King]

[sql]ALTER TABLE tbl_name CHANGE old_field new_field[/sql]

[gengar003]

Another question:

in

PHP Code:

$keeparray = $DB_site->query("SELECT 'name','catchname','data' FROM tacemonquery WHERE name='$th_old_name'"); 


I'd reference "name", "catchname" and "data" by

$keeparray['name'] or $keeparray[name], right? Because it's not working, Maybe something's wrong with the query....

Help?

also, this:

PHP Code:

$DB_site->query("ALTER TABLE user CHANGE '$keeparray[catchname]', '$th_rong_name'"); 


Returns an error, PRESUMABLY because the two variables, both of which are set based on the keeparray mentioned above, are assigned no value... That aside, is the syntax right to change user field $keeparray[catchname] to $th_rong_name ?

[filburt1]

$keeparray['name'], only.

Second question:

PHP Code:

$DB_site->query("ALTER TABLE user CHANGE " . $keeparray['catchname'] . " $th_rong_name"); 


...assuming, of course, that $keeparay['catchname'] and $th_rong_name contain valid column names.

[gengar003]

Heh, thanx, it works now, It turns out that I needed to remove some quotes, since.......



anyway, it works now.



Once again, filburt saves the daY!