Create And Copy Table Concatenation Help

[BigTime]

Database one: schedules

Database two: schedulesArchive

 

I need to copy a table named foo from database one to database two and rename it to 2012_foo.

 

$usr = "user";
$pwd = "pass";
$db = "schedules";
$db2 = "schedulesArchive";
$host = "localhost";
# connect to database
$cid = mysql_connect($host,$usr,$pwd);
if (!$cid) { echo("ERROR: " . mysql_error() . "\n"); }

$year=Date("Y");
SQL = "CREATE TABLE $db2.$year_foo SELECT * FROM $db.foo";
$result = mysql_db_query($db,$SQL,$cid);
# check for error
if (!$result) { echo("ERROR: " . mysql_error() . "\n$SQL\n"); }

 

My problem is in the naming of the new table I want it to read schedulesArchive.2012_foo, but Im confused on how to get my statement to read the $year parameter inline in my query

 

Thanks in advance

Edited December 20, 2012 by BigTime

[twistedvengeance]

$usr = "user";
$pwd = "pass";
$db = "schedules";
$db2 = "schedulesArchive";
$host = "localhost";
# connect to database
$cid = mysql_connect($host,$usr,$pwd);
if (!$cid) { echo("ERROR: " . mysql_error() . "\n"); }


$year=Date("Y");
$db2 = $db2 . $year . "foo";
SQL = "CREATE TABLE $db2 SELECT * FROM $db.foo";
$result = mysql_db_query($db,$SQL,$cid);
# check for error
if (!$result) { echo("ERROR: " . mysql_error() . "\n$SQL\n"); }

[BigTime]

I'll give it a try thanks for your time

[BigTime]

slight modification:

 

$db2 = $db2 . $year . "foo";

 

 

to

 

$db2 = $db2 . "."  . $year . "_foo";

 

 

Got me to where I wanted to be. Thank you!