I'm having trouble getting INSERT INTO SET
to work. I know its not conventional and VALUE is suppose to be used. But the SET command does visually make inserting into fields easier. The first insert works with no problem but m_pos
does not post when I add the $pos1
variable. If I remove the $pos1
variable and input a string like "1" it works.
$pos1 = "1";
mysql_query("INSERT INTO social_info SET
m_id = '.intval($id).',
m_pos = '.$pos1.'"
);
$pos1 = "1";
mysql_query("INSERT INTO social_info SET
m_id = '.intval($id).',
m_pos = '.$pos1.'"
);
You have messed your syntax up a bit. Should be:
$pos1 = "1";
mysql_query("INSERT INTO social_info SET
m_id = ".intval($id).",
m_pos = ".$pos1
);
@@seanbreeden is correct you missing the "", it should be something like this.
$pos1 = "1"; mysql_query("INSERT INTO social_info SET m_id = '".intval($id)."', m_pos = '".$pos1.'");