Passing php variables in MySQL Queries

[adeptus]

Hi,

I am working on a number of functions where it would be very helpful to pass PHP variables into mysql queries for example:

$WK=Week; //Week is selected in htmlform and pased to function

$Table_Name="Waiver_Order_WK: $WK" //Table name string

$q2="CREATE TABLE $Table_Name (TeamID Integer,Pick INT UNSIGNED NOT NULL AUTO_INCREMENT,ADD INDEX (Pick))";

$r2=mysql_query($q2,$link1);

Will this create a table with the desired name or create a table with the name $Table_name. Is there a different syntax to accomplish this task?

Thanks!

Chris

[mystrymaster]

you have the right idea I am just not sure on the exact syntax with the addition of varibale and real text off the top of my head.

[coditoergosum]

Just put single quotes around your php vars.

Like this:

$q2="CREATE TABLE '$Table_Name' (TeamID Integer,Pick INT UNSIGNED NOT NULL AUTO_INCREMENT,ADD INDEX (Pick))";