MySQL插入表

Question

mysql_query("INSERT INTO contact_forms(name,ts,ip,email,option,msg)
        VALUES('".$name."', 
        NOW(),
        '".$_SERVER['REMOTE_ADDR']."', 
        '".$email."', 
        '".$option."', 
        '".$message."')");

For some reason this thing doesn't work. It throws no errors but it just doesn't work. Can someone tell me why?

Answer 1

Try

   $date = now();
   $ip = $_SERVER['REMOTE_ADDR'];
   $query = "INSERT INTO contact_forms (name,ts,ip,email,option,msg)
          VALUES('$name',
          '$date',
          '$ip',
          '$email',
          '$option',
          '$message')";