insertion failed in database

Try this:

  $query="INSERT INTO user_details values('".$r."','".$city."','".$from_city."','".$to_city."')";

  mysql_query($query);