rename table using variable

ginger_nur

hello all!
help me plsss...
id like to rename a table. however the new table name is request from the user<user enter new name in a form>. im just not sure how the syntax is.
let say the variable is $newname

  $rename="ALTER TABLE 'newtable' RENAME '$newname'" ;           

         mysql_query($rename)
         	or die ("couldn't rename")

i get the "couldn't rename" msg, meaning it cant execute the query.
ive check the newname posted by echoing it. nothing wrong with it.so i guess the prob is at the query syntax.

thanx in advance fellas!

JD_

try this:

$rename="RENAME TABLE 'newtable' TO '$newname'" ;            

         mysql_query($rename) 
             or die ("couldn't rename")

http://dev.mysql.com/doc/mysql/en/rename-table.html

ginger_nur

thanx jd.
however to no avail. i still got the error msg.

JD_

ok missing the database name why the manual dosent have that in i don't know this def works.

$rename="RENAME TABLE 'yourdatabase.newtable' TO 'yourdatabase.$newname'" ;             

         mysql_query($rename)  

             or die ("couldn't rename")

its best if your having trouble with querys to run it from phpmyadmin or similiar as you dont have to keep editing your code if your trying to get something to work.

hope that helps.