php / mysql INSERT INTO SET [关闭]

Question

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.'"
);

Answer 1

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