Jump to content


Photo

inserting variables into table


  • Please log in to reply
2 replies to this topic

#1 stikky

stikky
  • New Members
  • Pip
  • Newbie
  • 4 posts

Posted 01 September 2006 - 04:59 PM

hello, i am a complete beginner and I have been having trouble getting variables taken from a form into a mySQL table.
Yesterday, I only either got the variable names inserted (eg $fg), or I got a 'syntax error' message.
Today I extracted the values first, but no matter what I try I still get this error message:
Query failed: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ''test1','test2','test3','test3','test4','test5','test7','test8','test9') VALUES ' at line 1

This is an improvement, as these are the correct values (the fieldnames are also in variables).

Here is the code as it is now:

extract($customer);
extract($labels);
$sql = "INSERT INTO testing ('$firstName','$lastName','$company','$street','$city','$county','$phone','$email','$query') VALUES ('$fN','$lN','$cp','$stt','$cy','$coy','$ph','$el','$qu');";
$result = mysql_query($sql,$dbh) or die("Query failed: ".mysql_error());

$customer is the array of values, $labels is the array of fieldnames.
I have tried every variation on the theme I can think of. Please can someone help?


#2 .josh

.josh
  • Staff Alumni
  • .josh
  • 14,871 posts

Posted 01 September 2006 - 05:09 PM

take the quotes away from the field name variables (but leave the quotes around the data variables on)
Did I help you? Feeling generous? Buy me lunch! 
Please, take the time and do some research and find out how much it would have cost you to get your help from a decent paid-for source. A "roll-of-the-dice" freelancer will charge you $5-$15/hr. A decent entry level freelancer will charge you around $15-30/hr. A professional will charge you anywhere from $50-$100/hr. An agency will charge anywhere from $100-$250/hr. Think about all this when soliciting for help here. Think about how much money you are making from the work you are asking for help on. No, we do not expect you to pay for the help given here, but donating a few bucks is a fraction of the cost of what you would have paid, shows your appreciation, helps motivate people to keep offering help without the pricetag, and helps make this a higher quality free-help community :)

#3 stikky

stikky
  • New Members
  • Pip
  • Newbie
  • 4 posts

Posted 01 September 2006 - 05:34 PM

thanks that works fine now, silly me!




0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users