NukeCoder

Posted: Sat Dec 30, 2006 10:21 pm

Is this the wrong syntax to do so?

Code:

$db->sql_query("RENAME TABLE {$prefix}_croster_ribbons_$ribtitle2 TO {$prefix}_croster_ribbons_$ribtitle") OR die("Could not rename table");

I will google some more resources later Crying or Very sad

Site Admin Joined: Oct 25, 2004 Posts: 921

Try this instead...

Code:

$db->sql_query("RENAME TABLE ".$prefix."_croster_ribbons_$ribtitle2 TO ".$prefix."_croster_ribbons_$ribtitle") OR die("Could not rename table");

Posted: Sun Dec 31, 2006 2:45 pm

well snap...

That worked. It amazes me sometimes how the fix is so simple. I am not sure I would of ever even tried that or why the other doesn't work.

Thanks,
gotcha