mysql_query question

[Anon]

Is it possible to do something like this:

$id = 1;
$section = "one";

mysql_query("INSERT INTO links_$id ("$section"name, "$section") VALUES (blah, blah)")

This dosen't work but i'd be great if someone could figure it out.

[Anon]

Oh yeah forgot. What I need is the $section variable to work so it will be written like

mysql_query("INSERT INTO links_$id (onename, one) VALUES (blah, blah)")

[Anon]

I think you need to put $id in ''

[Anon]

Oh yeah forgot. What I need is the $section variable to work so it will be written like

mysql_query("INSERT INTO links_$id (onename, one) VALUES (blah, blah)")

[[deleted]]

Use concatenation to build your query:
$query="INSERT INTO links_".$id." (".$section."name,".$section.") values......";
echo $query;
mysql_query($query,$db_link_identifier);

[Anon]

Excellent. Thank you.