Jump to content


Photo

Php/mysql - Insert W/ Dynamic Column Names?


  • Please log in to reply
1 reply to this topic

#1 robmcfeters

robmcfeters
  • New Members
  • Pip
  • Newbie
  • 1 posts

Posted 28 June 2006 - 05:07 PM

I'm trying to get this query to work.

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);

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?

#2 fenway

fenway
  • Staff Alumni
  • MySQL Si-Fu / PHP Resident Alien
  • 16,199 posts
  • LocationToronto, ON

Posted 03 July 2006 - 02:12 AM

I'm not sure I understand... how can the user pick a random column???
Seriously... if people don't start reading this before posting, I'm going to consider not answering at all.




0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users