Jump to content

Archived

This topic is now archived and is closed to further replies.

robmcfeters

Php/mysql - Insert W/ Dynamic Column Names?

Recommended Posts

I'm trying to get this query to work.

[code]
PHP Code:
$name = $_POST['name'];
$bads = array(".", "/", ",", "&", "-", "@", "#", "%", "*", "(", " ", ")");
$newname = str_replace($bads,"",$name);
$score = $_POST['score'];

$connect = mysql_connect("test", "test", "test");
mysql_select_db(test, $connect) or die(mysql_error());
$query = "INSERT INTO dynamic_scores (" . $newname . ") VALUES ('$score')";
mysql_query($query);[/code]

However, this query definitely won't insert a row into the database. If I use a normal column name, instead of setting it to a variable, then it works...but I want to use the variable.

Any ideas?

Share this post


Link to post
Share on other sites
I'm not sure I understand... how can the user pick a random column???

Share this post


Link to post
Share on other sites

×

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.