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

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

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

Another question:

in 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:

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 ?

$keeparray['name'], only.

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

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!