Insert the values from the array into the column from the array?

Question

I am trying to run the following but am getting the following mysql error ?

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 'INSERT INTO hqfjt_chronoforms_data_addupdatelead SET f9f2ec4270a751f4f34980c325e' at line 2

 <?php
$user = $_POST[cf_uid];
$form = $_POST[uid];
$date = date("d-m-Y"); 
$query = mysql_query("UPDATE hqfjt_chronoforms_data_addupdatelead SET $form = $date 
 WHERE cf_uid = $user
") 
or die(mysql_error());
?>

what I am trying to do, is use the $USER to find the correct user record, then in that user record find the column $form and insert the $date into it,

EDIT >>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>

Ok this gets me halfway there, but still an error >>

<?php
$user = $_POST[cf_id];
$form = $_POST[uid];
$date = date("d-m-Y"); 
$query = mysql_query("UPDATE hqfjt_chronoforms_data_addupdatelead SET '".$form."' =     '".$date."' WHERE cf_id = '".$user."'")
or die(mysql_error());
?>

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 ''185cfb5654aacf3038e3f26491f227356b5d768f' = '30-12-2011' WHERE cf_id = '14'' at line 1

Rahul · Accepted Answer · 2011-12-30 18:57:37Z

1

This is not correct:

First you are trying to execute both select and insert together and second insert don't have set command ... I think you need an update command

update hqfjt_chronoforms_data_addupdatelead SET $form = $date 
WHERE $user = $user

OR, I think you are trying to do something like this

 INSERT INTO hqfjt_chronoforms_data_addupdatelead SELECT * FROM
hqfjt_chronoforms_data_addupdatelead WHERE $user = $user

EDIT: Try This:

<?php $user = $_POST["cf_uid"]; 
$form = $_POST["uid"]; 
$date = date("d-m-Y"); 
mysql_query('UPDATE hqfjt_chronoforms_data_addupdatelead SET "$form" = "$date" 
WHERE cf_uid = "$user"')   or die(mysql_error()); ?>

edited Dec 30, 2011 at 18:57

answered Dec 30, 2011 at 18:06

Rahul

78.1k14 gold badges80 silver badges132 bronze badges

Sign up to request clarification or add additional context in comments.

4 Comments

Iain Simpson Over a year ago

Hi, what I am trying to do, is use the $USER to find the correct user record, then in that user record find the column $form and insert the $date into it, sounds easy when you say it like that lol, as for coding it though....

Rahul Over a year ago

Well, then you need the update command I have mentioned in my answer

Iain Simpson Over a year ago

I have tried using this >>, but am getting Unknown column '6dd52fad65bf18b824db855ea325deb8' in 'where clause', 6dd52fad65bf18b824db855ea325deb8, exists and is id of the record, so im not sure why I get the error >>

Iain Simpson Over a year ago

<?php $user = $_POST[cf_uid]; $form = $_POST[uid]; $date = date("d-m-Y"); $query = mysql_query(" UPDATE hqfjt_chronoforms_data_addupdatelead SET $form = $date WHERE cf_uid = $user ") or die(mysql_error()); ?>

Brodie · Accepted Answer · 2011-12-30 18:40:32Z

0

as per your comment you'd be fine just doing a

$query = "UPDATE table SET $forms = $date WHERE cf_uid = $user";
$success = mysql_query($query);

or you can put it all into one line as well. But if you're just looking to update there's no need to SELECT ALL the data from the user. That's what the "WHERE" is for.

edited Dec 30, 2011 at 18:40

answered Dec 30, 2011 at 18:07

Brodie

8,7979 gold badges38 silver badges55 bronze badges

6 Comments

Iain Simpson Over a year ago

Hi, I think I might have been using the select when I didnt need it, what I am trying to do, is use the $USER to find the correct user record, then in that user record find the column $form and insert the $date into it,

Brodie Over a year ago

updated my answer. but i think the gentleman below me answered it correctly first.

Iain Simpson Over a year ago

I have tried using this >>, but am getting Unknown column '6dd52fad65bf18b824db855ea325deb8' in 'where clause', 6dd52fad65bf18b824db855ea325deb8, exists and is id of the record, so im not sure why I get the error >>

Iain Simpson Over a year ago

<?php $user = $_POST[cf_uid]; $form = $_POST[uid]; $date = date("d-m-Y"); $query = mysql_query(" UPDATE hqfjt_chronoforms_data_addupdatelead SET $form = $date WHERE cf_uid = $user ") or die(mysql_error()); ?>

Brodie Over a year ago

hmmm try doing $query = "UPDATE table SET '".$forms."' = '".$date."' WHERE cf_uid = '".$user."'"); the quotations might help? took a look around and saw that as a solution

|

Collectives™ on Stack Overflow

Insert the values from the array into the column from the array?

2 Answers 2

4 Comments

6 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

4 Comments

6 Comments

Your Answer

Sign up or log in

Post as a guest

Related