php从数组中将一个字符写入数据库

Question

I have an array

// Send to recipients...
$goodFriends = array_unique($goodFriends);
$MAIL->sendMail('', // Not used..
                  $goodFriends,
                  $_POST['name'],
                  $_POST['email'],
                  str_replace(array('{website}','{sender}'),array(WEBSITE_NAME,$_POST['name']),$msg_subject3),
                  $MAIL->template(FOLDER_PATH.'templates/email/friend.html')
                );

if(is_array($goodFriends)){                      
  foreach($goodFriends as $value){
    $user_id = (int) $value['user_id'];
    $name = mysql_real_escape_string( $value['name'] );
    $email = mysql_real_escape_string( $value['email'] );
    $referrer = mysql_real_escape_string( $_POST['email'] );
    $date = date('Y-m-d H:i:s');

    $sql = "INSERT INTO referred (id, emailid, name, date, referredby) values ('$user_id', '$email', '$name', '$date', '$referrer')";
    mysql_query($sql) or exit(mysql_error()); 
  }

  $len = strlen($query) - 1;
  $query = substr($query,0,$len); //removing last ,
  $sql_query = mysql_query($query);

} 

It writes the referer as a email into database, but now only stores the first character of the referred peoples names and emails

What am I doing wrong?

Answer 1

Can you check your Table structure, may you forgot to add sufficient space to emailid and name fields??